RE: [PHP-DB] auto increment From: Howard Picken (howard <email protected>)
Date: 06/14/02

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 <email protected>]
Sent: Friday, 14 June 2002 11:27 AM
To: php-db <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