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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
