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


-- 
Eric Bergen
eric.bergen@stripped
http://www.bleated.com
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