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
3359
September 17, 2007 09:28AM
2456
September 20, 2007 08:04AM
2368
October 04, 2007 01:34AM
2416
October 05, 2007 11:28AM
Re: Transaction
2405
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.