Hi, You can probably use "SELECT LAST_INSERT_ID()" which keeps auto-increment values on a per connection basis. See: http://dev.mysql.com/doc/mysql/en/getting-unique-id.html
/Johan
mel list_php wrote:
Hi!
I have a database where several users can connect and input data.
I managed to have my insert queries as atomic, but I was wondering about one special case: I make one insert, and retrieve the last id inserted by mysql because I need to update an other table with that id.
- if one user inserts and retrieves the id, but between both one other has inserted something the id returned will be the right one?
- or do I have to lock my table, execute the query, retrieve the id, unlock the table?
- is there a way to make an atomic query with this that would avoid me to use locks?
Thanks a lot for any help,
Melissa
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
