Thanks Eric, but I can let it increment because I cannot have a gave in the
numbers. I think I will need to use MAX() in this case.
On 1/17/05 8:14 PM, "Eric Bergen" <eric.bergen@stripped> wrote:
> Just let it increment. Keeping it incremented is MySQL's way ot
> insuring that the same id doesn't get used twice for different
> records. It's doing everything correctly.
> On Mon, 17 Jan 2005 19:06:45 -0500, Andre Matos
> <amatos@stripped> wrote:
>> Hi List,
>> I have a field in one of my tables that uses auto-increment from MySQL
>> 4.1.8-nt (Windows XP).
>> My problem is to get the last insert ID when the insert fails and I use
>> rollback. The MySQL is still incrementing the field. How can I avoid this if
>> it is possible? I am trying to avoid to use the function MAX() to get the
>> last ID inserted.
>> Thanks for any help.
>> Andre Matos
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1