AUTO_INCREMENT problems
| From: | Phil Schwarzmann | Date: | Thu, 17 Jan 2002 17:35:35 +0000 |
| Subject: | AUTO_INCREMENT problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-80944@lists.php.net to get a copy of this message | ||
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!