List:General Discussion« Previous MessageNext Message »
From:Andre Matos Date:January 18 2005 2:27am
Subject:Re: Rollback and INSERT_ID() or LAST_INSERT_ID()
View as plain text  
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.

Thanks.

Andre



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.
> 
> -Eric
> 
> 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
>> 
>> --
>> Andre Matos
>> amatos@stripped
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>> 
>> 
> 

-- 
Andre Matos
amatos@stripped


Thread
Rollback and INSERT_ID() or LAST_INSERT_ID()Andre Matos18 Jan
  • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Eric Bergen18 Jan
    • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Andre Matos18 Jan
      • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Paul DuBois18 Jan
        • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Andre Matos18 Jan
        • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Joerg Bruehe18 Jan
          • Re: Rollback and INSERT_ID() or LAST_INSERT_ID()Clint Edwards18 Jan