Alter table syntax question -

2006-03-01 Thread bobgoodwin
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 table T1. I would

Re: Alter table syntax question -

2006-03-01 Thread gerald_clark
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

Re: alter table syntax

2002-12-08 Thread kayamboo
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

Re: alter table syntax

2002-12-08 Thread Dan Nelson
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)

Re: Re: alter table syntax

2002-12-08 Thread kayamboo
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

Re: alter table syntax

2002-12-06 Thread Dan Nelson
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

re: Re: alter table syntax

2002-12-06 Thread Egor Egorov
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 syntax

2002-12-05 Thread kayamboo
sql, mysql, query Hello folks This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra |

Re: alter table syntax

2002-12-05 Thread R. Hannes Niedner
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

Re: alter table syntax

2002-12-05 Thread kayamboo
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

alter table syntax error

2002-02-18 Thread Gary Prosser
I've read and re-read the manual and searched mailing list archive and still can't see what is wrong with this statement - I'm sure someone can put me out of my misery ! I'm simply trying to move the position of the Cat2 column. mysql alter table bollinks3 change Cat2 Cat2 smallint(5) unsigned

alter table syntax error

2002-02-18 Thread Victoria Reznichenko
Gary, Monday, February 18, 2002, 2:30:03 PM, you wrote: GP I've read and re-read the manual and searched mailing list archive and still GP can't see what is wrong with this statement - I'm sure someone can put me GP out of my misery ! I'm simply trying to move the position of the Cat2 GP