using one single sql statement, how do i update the auto_increment id column of a row to have the new highest id in the table?
in other words: how do i make a row seem like it was just inserted? i know how to do it with two statements, but i want to do it with one to ensure nothing goes wrong: $newid = get_value("select max(id) from user") + 1; run_query("update table mytable set id = '$newid' where id = '$oldid' "); hope someone can help. thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]