Hallo,
ich kann es gerade nicht ausprobieren, aber warum lässt du die table option nicht einfach weg?
MySQL 5.0.3 Reference - CREATE TABLE
An integer column can have the additional attribute AUTO_INCREMENT. When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. Typically this is value+1, where value is the largest value for the column currently in the table. AUTO_INCREMENT sequences begin with 1.
Grüße vom marabu