SELECT MAX(ID) ... ?
might maybe help if you want to cross connection ??
> The LAST_INSERT will return the last saved AUTO_INCREMENT for that
> connection and for no other connection. So if two users on different
> connections save at the same time, there will not be a problem.
> Miguel Cardenas wrote:
>> Hello list
>> I need to retrieve the AUTOINCREMENT field from the just inserted
>> note that I say JUST INSERTED and not LAST INSERTED.
>> It is for a website that accepts forms submitted by users, but it may
>> in some time that two or more forms are submitted simultaneously by
>> different users, so not necessarily the last inserted could be the just
>> inserted, or yes?
>> Thanks for any help
Dr. Werner Van Belle