Well, if younjust want to reset the auto-increment:
ALTER TABLE `tablename` AUTO_INCREMENT =235
But i would reconsider, use one table as the main, with autoincrement and just
use that id to add itens in the next table.
Rafael Machado Dohms
PHP Professional
Blog: http://www.rafaeldohms.com.br - AJAX, PHP, XML, JavaScripy, MySQL
----- Original Message -----
From: Francisco Antonio Vieira Souza
To: [email protected]
Sent: Monday, July 24, 2006 3:03 PM
Subject: [php_mysql] How to change auto_increment fields
I have 2 tables and in the first tablem some rows were lost, now I
need to add them back and set the auto_increment field valeu to the
same I have already in the second table (for keeping the integrity).
So my question is: How can I update/change the value of a
auto_increment field?
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/WktRrD/lOaOAA/yQLSAA/CefplB/TM
--------------------------------------------------------------------~->
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
