List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 18 1999 6:09pm
Subject:Re: No AUTO_INCREMENT ??
View as plain text  
At 17:51, 19990818, Seb wrote:
>When I ask :
>CREATE TABLE static (id MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, descr
>VARCHAR(100));
>--->Error near 'AUTO_INCREMENT ??
>On the host this is a 3.21 MySQL version.

The order of items is important.  Read the manual section CREATE TABLE
for the full info.  Basically AUTO_INCREMENT has to be before PRIMARY
KEY.

Tim
Thread
No AUTO_INCREMENT ??Seb18 Aug
  • Re: No AUTO_INCREMENT ??Thimble Smith18 Aug
RE: No AUTO_INCREMENT ??Darren L Sweeney18 Aug