FW: [PHP-DB] --- correction --- auto increment From: José Moreira (jmoreira <email protected>)
Date: 06/14/02

-----Mensagem original-----
De: José Moreira [mailto:jmoreira <email protected>]
Enviada: sexta-feira, 14 de Junho de 2002 9:53
Para: Daniele Baroncelli
Cc: Php-Db
Assunto: RE: [PHP-DB] auto increment

hello, i think u have to create the series yourself ... before u insert
every record, first calculate the next value :

-------> "SELECT MAX(ID)+1 AS NEXT FROM TABLE"

then u insert ...

hope it helps ...

-----Mensagem original-----
De: Daniele Baroncelli [mailto:daniele <email protected>]
Enviada: sexta-feira, 14 de Junho de 2002 2:27
Para: php-db <email protected>
Assunto: [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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php