INSERT ON DUPLICATE KEY UPDATE with last_insert_id()

INSERT ON DUPLICATE KEY UPDATE with last_insert_id()

search resultsMySQL ON DUPLICATE KEY - last insert id? - Stack Overflow
I have the following query: INSERT INTO table (a) VALUES (0) ON DUPLICATE
KEY UPDATE a=1 I want the ID of either the insert or the update. Usually I
run a second ...
stackoverflow.com/questions/778534 - Cached

MySQL Bugs: #27033: LAST_INSERT_ID returns 0 on using INSERT ...
Bug #27033: LAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY
UPDATE ... Submitted: 11 Mar 2007 14:09: Modified: 20 Mar 2007 17:43:
Reporter:
bugs.mysql.com/bug.php?id=27033 - Cached

duplicate key | PHP Musings - Charles Reace: Interactive Web ...
INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE
id=LAST_INSERT_ID(id), c=3; ... the old row is deleted before the new row
is inserted. ...
www.charles-reace.com/blog/tag/​duplicate-key - Cached

Insert On Duplicate Key Update and Last_Insert_ID() | PHP Musings
REPLACE works exactly like INSERT, except that if an old row in the table
has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the
old row ...
www.charles-reace.com/blog/2010/12/06/​insert-on... - Cached

Bug #19243 wrong LAST_INSERT_ID() after ON DUPLICATE KEY UPDATE
Bug #19243: wrong LAST_INSERT_ID() after ON DUPLICATE KEY UPDATE:
Submitted: 21 Apr 2006 4:45: Modified: 13 Sep 2006 17:45: Reporter: Nathan
Cheng: Email Updates:
bugs.mysql.com/bug.php?id=19243 - Cached

PHP: mysql_insert_id - Manual - PHP: Hypertext Preprocessor
Forget about using MAX to get the last inserted id. ... If you insert a
data row by using the ON DUPLICATE KEY UPDATE clause in an
INSERT-statement, ...
php.net/manual/en/function.mysql-insert-​id.php - Cached

MySQL Lists: mysql: 'on duplicate key update' and 'last ...
In that case I want it to appear as though it wasn't there before and has
been inserted, returning the new value of id. ... duplicate key update'
and 'last_insert_id ...
lists.mysql.com/mysql/199533 - Cached

MySQL :: MySQL 5.0 Reference Manual :: 13.2.5.3 INSERT ... ON ...
If you specify ON DUPLICATE KEY UPDATE, and a row is inserted that would
cause a duplicate value in a UNIQUE index or ... ON DUPLICATE KEY UPDATE
id=LAST_INSERT_ID ...
dev.mysql.com/doc/refman/5.0/en/insert-​on-duplicate.html - Cached

mysql - INSERT ON DUPLICATE KEY UPDATE with last_insert_id ...
Stack Overflow is a question and answer site for professional and
enthusiast programmers. It's 100% free, no registration required.
stackoverflow.com/questions/13623258/​insert-on-duplicate... - Cached

PDO::lastInsertId() and INSERT... ON DUPLICATE KEY UPDATE
Hello! In an application I'm writing, I use a INSERT... ON DUPLICATE KEY
UPDATE query, through the PDO class. In the rest of my script I need the
id of the row that ...
www.sitepoint.com/forums/​showthread.php?556449-PDO-last... - Cached