From: Ben Clewett
Date: April 22 2008 8:29am
Subject: Re: auto_increment
List-Archive: http://lists.mysql.com/mysql/212432
Message-Id: <480DA1EE.2090904@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


You are right, I've tried 5.0.18 and 5.0.45 which work.

There must have been a bug in 5.0.41 with which I used test the question...

I belive the question has been answered by now anyway :)

Ben


Sebastian Mendel wrote:
> 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
>