Re: LAST_INSERT_ID() AND UPDATE STATEMENTS
last_insert_id() is generated from an INSERT statement, for the auto_increment value.
There is no last_insert_id when you run an UPDATE statement. UPDATE does not affect auto_increment value.
Subject
Views
Written By
Posted
17171
May 26, 2007 03:06AM
Re: LAST_INSERT_ID() AND UPDATE STATEMENTS
4761
May 27, 2007 03:03AM
4340
May 27, 2007 06:34AM
5770
May 27, 2007 04:38PM
3687
May 28, 2007 12:31AM
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.