Try... ALTER TABLE patients CHANGE id id MEDIUMINT not null primary key AUTO_INCREMENT
/dkm ----- Original Message ----- From: "Phil Schwarzmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 12:35 PM Subject: [PHP] AUTO_INCREMENT problems > 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]