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
2420
September 23, 2005 09:20AM
1458
September 23, 2005 10:48AM
1522
September 23, 2005 10:56AM
1460
September 23, 2005 11:20AM
1577
September 23, 2005 11:38AM
1444
September 23, 2005 03:33PM
1435
September 23, 2005 04:25PM
1381
September 23, 2005 04:59PM
1600
September 26, 2005 02:30PM
Re: Performance of ON DUPLICATE KEY and other options?
1449
November 10, 2005 10:12AM
1495
November 10, 2005 10:26AM
1417
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.