Hello!!

ALTER TABLE $table1 AUTO_INCREMENT = 242

Replace the $table with your table's name and replace the end number 
with what number you want.

Dan


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 
> 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

Reply via email to