On Thu, Jul 26, 2001 at 08:59:25PM +0200, Danni Efraim wrote:
I am only a MySQL-novice, so correct me if I am wrong, but as long as your Zope instances have separate connections, shouldn't last_insert_id() return the last inserted id of that particular session, and thus be safe anyhow?
If not, how about using transactions, or (icky icky yuk!) locking the table?
I asked this cause' i though it could be possible zope start executing a script, stop before its end and switch to another one, finishes this one and come back to the old one. So if there are insert queries into both of them, the first one would fetch a wrong last_insert_id(), got the ideia? Does this happen when using a cluster of servers (ZEO)? May some one explain me if such scenario may happen!
And finally, wouldn't such a question be better asked on a MySQL-list?
/Danni
Hi folks!
I have a table it has an auto increment fields. How could i have the id id insert by my last query atomically? I know i could use last_insert_id() function with MySQL, but since my mysql handler is shared by many instances of Zope, i cannot garantee that no other query runs between the insert and the select last_insert_id queries.
Any ideia ?
-- "Of ______course it's the murder weapon. Who would frame someone with a fake?"