Re: Performance of ON DUPLICATE KEY and other options?
Apologies for hijacking your thread, Mark.
I have a much more simple problem that I suspect you may be able to help me with. I'm also using the ON DUPLICATE KEY UPDATE feature, and am having trouble extracting the last inserted / updated key.
SELECT LAST_INSERT_ID() will return the id of any new rows inserted, however it does not return the id of rows that were already present in the table and were UPDATEd. Did you mention a way of getting this function to also return the id of UPDATEd rows?
Thanks in advance,
Jamie
Subject
Views
Written By
Posted
2236
September 23, 2005 09:20AM
1347
September 23, 2005 10:48AM
1421
September 23, 2005 10:56AM
1347
September 23, 2005 11:20AM
1486
September 23, 2005 11:38AM
1357
September 23, 2005 03:33PM
1355
September 23, 2005 04:25PM
1286
September 23, 2005 04:59PM
1505
September 26, 2005 02:30PM
Re: Performance of ON DUPLICATE KEY and other options?
1370
November 10, 2005 10:12AM
1409
November 10, 2005 10:26AM
1328
November 10, 2005 02:19PM
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.