Re: Transaction
SELECT LAST_INSERT_ID() or mysql_insert_id() ?
If you execute SELECT LAST_INSERT_ID() be sure to executed after the INSERT itself (as Cheuksan noted).
You can also just use mysql_insert_id() and save the extra round-trip.
--
Jan Kneschke, MySQL Enterprise Tools
Subject
Views
Written By
Posted
3335
September 17, 2007 09:28AM
2444
September 20, 2007 08:04AM
2348
October 04, 2007 01:34AM
2396
October 05, 2007 11:28AM
Re: Transaction
2393
October 10, 2007 03:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.