hello, I think the following may solve your problem.
alter table patients change id id mediumint (9) default 0 not null primary key auto_increment; On Thu, 17 Jan 2002, Phil Schwarzmann wrote: > I have an exsisting table without any rows. I tried to add a new column > to it and make it an "auto increment" column. But when I do I get > this... > > ALTER TABLE patients CHANGE id id MEDIUMINT (9) DEFAULT not null > AUTO_INCREMENT > > MySQL said: You have an error in your SQL syntax near '' at line 1 > > ..what did i do wrong? > > Thanks! > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]