If you run an optimize or a repair on your datafile it'll set the autoincrememtn back to next number
Howard -----Original Message----- From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 June 2002 11:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] auto increment Hi guys, The auto_increment field of my MySQL table gives me "258", although the higher value at the moment is "241". I deleted the latest records, thinking that also the auto_increment would decrease, but this is not. I would like to know if there is a way to bring the auto_increment back to the higher value + 1. Cheers Daniele -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
