Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save dqduc/1f9f3b5f1ddf18843a671cf510ad8e3f to your computer and use it in GitHub Desktop.
Save dqduc/1f9f3b5f1ddf18843a671cf510ad8e3f to your computer and use it in GitHub Desktop.
MySQL - Get id of updated rows
# http://stackoverflow.com/questions/1388025/how-to-get-id-of-the-last-updated-row-in-mysql
# single row update
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;
# Multiple rows updated
SET @uids := null;
UPDATE footable
SET foo = 'bar'
WHERE fooid > 5
AND ( SELECT @uids := CONCAT_WS(',', fooid, @uids) );
SELECT @uids;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment