Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save cmpscabral/c6b8599f8c85f7ce964f0adf84b7b434 to your computer and use it in GitHub Desktop.
Save cmpscabral/c6b8599f8c85f7ce964f0adf84b7b434 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