Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

[Eric Bergen]

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