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