Re: No AUTO_INCREMENT ??

[Thimble Smith]

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