From: Ed Carp
Date: March 12 1999 7:21pm
Subject: Re: AUTO_INCREMENT Limits to 256 records
List-Archive: http://lists.mysql.com/mysql/140
Message-Id: <005201be6cbe$28fce140$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>If you want to use the AUTO_INCREMENT feature to give it new values to
TicketNumber,
>you have to leave this field out.


[...]

>But if you only substituted the real TicketNumber value through its name,
then your dump has two INSERT's with the same TicketNumber
>value (which should be = 256).


I have also had success setting an auto_increment field to 0.