bobgoodwin wrote:
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous
pages of the "reference manual" and stuff on Google but still can get
the proper commands and syntax to alter the following
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 2:06 AM
Subject: Re: alter table syntax
> In the last episode (Dec 09), k
Thanks for the suggestions.
It worked fine
regards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 11:36 PM
Subject: re: Re: alter table syntax
> kayamb
In the last episode (Dec 09), kayamboo said:
> I don't get you.
> But when I executed the drop table syntax fromt he command line, the result
> was this error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
> (errno: 150
an you make me clear?
regards
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>; "R. Hannes Niedner"
<[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 2:
kayamboo,
Friday, December 06, 2002, 9:15:04 AM, you wrote:
k> When I tried to drop the key, this was the error
k> mysql> alter table town_db drop primary key ;
k> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db'
k> (errno: 150)
k> I suppose some lock in the index somew
In the last episode (Dec 06), kayamboo said:
> When I tried to drop the key, this was the error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno:
>150)
And what does "perror 150" return (it's a shell command, not
R. Hannes Niedner" <[EMAIL PROTECTED]>
To: "MySQL Mailinglist" <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 3:50 PM
Subject: Re: alter table syntax
> ALTER TABLE town_db1 DROP PRIMARY KEY;
> ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity );
>
> On
ALTER TABLE town_db1 DROP PRIMARY KEY;
ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity );
On 12/5/02 10:31 PM, "kayamboo" <[EMAIL PROTECTED]> wrote:
> sql, mysql, query
>
> Hello folks
>
> This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB
>
> +-+--+
