Kelv's Programming Pages
Geeky Stuff
Programming Index
Apache, Slack and gdbm
JPass password maker
HTgen htpasswd maker
JVC Camcorders & DV
Firefox & RealPlayer
Thunderbird URLs
PHP and PGP
MySQL auto_increment
PostgreSQL Stuff
Flex JSON Post
ndiswrapper cards
SATA & Ubuntu installer
Articles
Monarch Computers
Links Elsewhere
The Kelv wide web
Jokes and silly stuff
Web development
Skunk Anansie
X11 Telco and Gravity
If you liked this site, please feel free to help me out with the upkeep!
Home
>
Programming
>
MySQL - Resetting auto_increment
Many times when testing data written to a table during code development I have needed to reset auto_increment back to zero, but I always forget the syntax, so here it is...
ALTER TABLE tbl_name AUTO_INCREMENT = 0