Skip to content

Instantly share code, notes, and snippets.

@alancoleman

alancoleman/update_column_with_incremented_value.sql

Last active August 29, 2015 14:11
Show Gist options
  • Save alancoleman/12b1693f94584163f8e2 to your computer and use it in GitHub Desktop.
Save alancoleman/12b1693f94584163f8e2 to your computer and use it in GitHub Desktop.
Download ZIP
Update a table column with an incremented value
Raw
update_column_with_incremented_value.sql
UPDATE table AS t
SET t.id = '';
SET @rank:=0;
update table AS t
set t.id =@rank:=@rank+1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment