Skip to content

Instantly share code, notes, and snippets.

@ryzr

ryzr/reset AI

Created September 22, 2015 01:24
Show Gist options
  • Save ryzr/5e83106011fc96846751 to your computer and use it in GitHub Desktop.
Save ryzr/5e83106011fc96846751 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
reset AI
SET @count = 0;
UPDATE `tablename` SET `tablename`.`id` = @count:= @count + 1;
ALTER TABLE `tablename` AUTO_INCREMENT = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment