as luck might have it, i have solved my own problem. thanks for the help people have already given me. what i needed to do (it seems?) is use SET INSERT_ID *before* doing the ALTER TABLE, like this: mysql> set insert_id=7; Query OK, 0 rows affected (0.00 sec) mysql> alter table fixtures modify column id int auto_increment; Query OK, 7 rows affected (0.01 sec) Records: 7 Duplicates: 0 Warnings: 0 i guess what this does is lets mysql know where to start counting for the auto_increment, so it doesnt complain about the cryptic "ERROR 1062: Duplicate entry '1' for key 1" thanks again, -jon _____________________________________________________________________________ NOW USE: [EMAIL PROTECTED] * http://scribble.com/jon/ * sito.org * gracies.org "A talent is formed in stillness, a character in the world's torrent." -- Johann Wolfgang von Goethe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php