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/...increment.html

--
Sebastian Mendel