Warning: Undefined array key "action" in /home/bakers/html/entryreply.php on line 5

Warning: Undefined variable $output in /home/bakers/html/entryreply.php on line 50

Warning: Undefined array key "EntrySubject" in /home/bakers/html/entryreply.php on line 51

Warning: Undefined variable $logintext in /home/bakers/html/entryreply.php on line 97

Warning: Undefined variable $reply_name in /home/bakers/html/entryreply.php on line 103

Warning: Undefined variable $reply_email in /home/bakers/html/entryreply.php on line 104
Perturb.org - interesting technology related things from around the internet

MySQL: Reset AUTO_INCREMENT

I have a MySQL table that I deleted a large amount of records from. Then all new records are inserted with the AUTO_INCREMENT still assuming the table had all those records in it. Fortunately you can reset the internal AUTO_INCREMENT count for a given table:

ALTER TABLE TableName AUTO_INCREMENT = 987;

This will set the AUTO_INCREMENT counter to 987. Thus all records inserted after that will start at 988. Unless there are records with a higher value than the auto_increment, then it will use that higher value + 1. Pretty handy.



Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 18.212.120.195
To prevent spam please submit by clicking the kitten: