How to get id when doing UPDATE request?

Question

MySQL

When executing an INSERT query, you can get the id of the last record through the mysql_insert_id () function, but when executing an UPDATE, the auto-increment mechanism is not affected and the function returns 0. Google on this problem issues dances with a tambourine around SELECT and additional columns. Is there any nice solution to this problem? ...or some other function that I didn't find?

Answer 1

When executing an INSERT query, you can get the id of the last record using the mysql_insert_id() function

Not true. mysql_insert_id() returns the ID of the inserted record.
If you need a record with the maximum ID - SELECT MAX(id) FROM ...
What do you want to get with UPDATE?

Answer 2

In general, the answer has already been given, but it is incorrect.
That's how you can.

UPDATE /* */ SET `id` = LAST_INSERT_ID(`id`), /* */