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
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:19 AM
Subject: Re: alter table syntax
In the last episode (Dec 06), kayamboo said:
When I tried to drop
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)
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
kayamboo,
Friday, D
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 an SQL
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 somewhere
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
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 12/5/02 10:31 PM, kayamboo [EMAIL PROTECTED] wrote:
sql, mysql, query
Hello folks
This is my table
