How to get ID of the last updated row in MySQL?

by

I’ve found an answer to this problem 🙂

SET @update_id := 0;
UPDATE some_table SET column_name="value", id = (SELECT @update_id := id)
WHERE some_other_column = 'blah' LIMIT 1; 
SELECT @update_id;

EDIT by aefxx

This technique can be further expanded to retrieve the ID of every row affected by an update statement:

SET @uids := null;
UPDATE footable
   SET foo = 'bar'
 WHERE fooid > 5
   AND ( SELECT @uids := CONCAT_WS(',', fooid, @uids) );
SELECT @uids;

This will return a string with all the IDs concatenated by a comma.

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. how to write php code for the key press enter button when fill the form?
  3. Create hyperlink from html table row to open record on a new page
  4. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  5. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  6. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  7. How to resolve ambiguous column names when retrieving results?
  8. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  9. Maximum execution time in phpMyadmin
  10. PHP PDO – Num Rows
  11. Post and get at the same time in php
  12. MySQL – Access denied for user [duplicate]
  13. Calling stored procedure with Out parameter using PDO
  14. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  15. How to display an BLOB image stored in MySql database?
  16. How to bind LIKE values using the PDO extension?
  17. How do I set the selected item in a drop down box
  18. Fatal error: Call to undefined function mysqli_result()
  19. access denied for user @ ‘localhost’ to database ” [closed]
  20. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  21. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  22. PHP 7 RC3: How to install missing MySQL PDO
  23. How can I employ “if exists” for creating or dropping an index in MySQL?
  24. PHP MySQL pagination with random ordering
  25. Using utf8mb4 with php and mysql
  26. how do I get month from date in mysql
  27. MySQL, how to insert null dates
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment