I advise you to use mysqlmyadmin. because this kind of executions are very easy in mysqlmyadmin
[EMAIL PROTECTED] wrote: 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] --------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/7EuRwD/fOaOAA/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/
