Skip to content

Instantly share code, notes, and snippets.

@sandasan

sandasan/reorderAutoIncrementIDs.sql

Forked from carloscarcamo/reorderAutoIncrementIDs.sql
Created September 3, 2021 12:50
Show Gist options
  • Save sandasan/03c25892cf4cd0892935d6736e618a1c to your computer and use it in GitHub Desktop.
Save sandasan/03c25892cf4cd0892935d6736e618a1c to your computer and use it in GitHub Desktop.
Download ZIP
Reorder auto increment IDs on MySQL
Raw
reorderAutoIncrementIDs.sql
SET @count = 0;
UPDATE table_name SET table_name.id = @count:= @count + 1;
ALTER TABLE table_name AUTO_INCREMENT = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment