RE: [PHP-DB] auto increment
| From: | Howard Picken | Date: | Fri, 14 Jun 2002 08:29:27 +0000 |
| Subject: | RE: [PHP-DB] auto increment | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19801@lists.php.net to get a copy of this message | ||
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:daniele@baroncelli.com]
Sent: Friday, 14 June 2002 11:27 AM
To: php-db@lists.php.net
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