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" <eric.bergen@stripped> 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
> <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
>>
>>
>
--
Andre Matos
amatos@stripped
