How to return id when updating ON DUPLICATE KEY UPDATE?

Question

PHP

Good evening!
There is the following request:

INSERT INTO `group_attributes`
VALUES (NULL, :title)
ON DUPLICATE KEY UPDATE title = :title

Using the PDO function in php lastInsertId, I get the id if a new record is inserted, but the id does not update when it is updated. Please tell me the solution to this problem

Answer 1

ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id)
Documentation - dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate...

Answer 2

well last insert Id speaks for itself. check the return, if the id has not arrived, pull it out with a query - SELECT id FROM table WHERE title = :title.