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
3349
September 17, 2007 09:28AM
2452
September 20, 2007 08:04AM
2359
October 04, 2007 01:34AM
2406
October 05, 2007 11:28AM
Re: Transaction
2401
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.