 |
 |
 |
 |
|
|
Date: 06/14/02
- Next message: Jason Wong: "Re: [PHP-DB] problem with login script"
- Previous message: Martin Adler: "[PHP-DB] REGEXP problem"
- In reply to: Daniele Baroncelli: "[PHP-DB] auto increment"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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, daniele <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
- Next message: Jason Wong: "Re: [PHP-DB] problem with login script"
- Previous message: Martin Adler: "[PHP-DB] REGEXP problem"
- In reply to: Daniele Baroncelli: "[PHP-DB] auto increment"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]