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
> 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