MySQL Forums
Forum List  »  Router & Proxy

Re: Transaction
Posted by: Jan Kneschke
Date: October 10, 2007 03:51AM

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

Options: ReplyQuote


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.