Ben Clewett schrieb:
> Are you sure, I just get:
>
> CREATE TABLE ...
>
> ERROR 1075 (42000): Incorrect table definition; there can be only one
> auto column and it must be defined as a key
the mentioned CREATE TABLE is fine and works
> On version 5.0.41. What version are you using?
this works on all versions, and the example is from the MySQL manual
http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html--
Sebastian Mendel

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.