In my system, I include a connection file with my parameters (host,user,pass).This is the details of the account allowed to establish the connection with the mysql server.
When 2 users are connecting to the database (through the web), they will use the same details (host,user,pass) for the connection.
Does that mean that they are sharing the same mysql connection (and in that case will I need a lock?) or are they each of them opening their own connection?
Can I check that somewhere?
Thanks a lot.
From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" <mysql@lists.mysql.com> To: mel list_php <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: last_insert_id Date: Tue, 15 Feb 2005 10:50:40 +0000
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?
Last_insert_id() is consistent on a per-connection basis, meaning you don't need to use lock (hopefullly !)
http://dev.mysql.com/doc/mysql/en/getting-unique-id.html
btw, what do you mean by : "I managed to have my insert queries as atomic". Because if you do : INSERT .... it's already suppose to be atomic.
HIMH.
-- Philippe Poelvoorde COS Trading Ltd.
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger 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]
