Skip to content

Instantly share code, notes, and snippets.

@yurrriq

yurrriq/MySQL - reset counter

Created December 28, 2013 21:08
Show Gist options
  • Save yurrriq/8164222 to your computer and use it in GitHub Desktop.
Save yurrriq/8164222 to your computer and use it in GitHub Desktop.
Download ZIP
I'm tired of forgetting how to reset the counter in MySQL, so I figured I'd make this my first gist. Big up to Google and http://stackoverflow.com/a/8923132
Raw
MySQL - reset counter
ALTER TABLE tablename AUTO_INCREMENT = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment