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
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
Articles
Links elsewhere
The Kelv wide web
Planet Linux UK
Jokes and silly stuff
UK web hosting
IMAP mail hosting
Wine gifts
Motivational management
Web development
Skunk Anansie
X11 SMS and RFID
Rest Assured
