In message <[EMAIL PROTECTED]>, Francisco Antonio Vieira Souza <[EMAIL PROTECTED]> writes >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?
You can just insert a value into a MySQL auto increment field, and it will accept it. UPDATE... SET incrementfield=1234; -- Pete Clark Andalucia in Sunny Southern Spain http://www.hotcosta.com/comm_1.htm 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/
