ALTER TABLE $table1 AUTO_INCREMENT = 242
Replace the $table with your table's name and replace the end number
with what number you want.
On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote:
> 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
> decrease, but this is not.
> I would like to know if there is a way to bring the auto_increment back
> the higher value + 1.
> 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