-----Mensagem original----- De: José Moreira [mailto:[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:[EMAIL PROTECTED]] Enviada: sexta-feira, 14 de Junho de 2002 2:27 Para: [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