ive gotten along pretty well with mysql and online docs. but now i am stumped and hoping for a little kick in the right direction. i have a column in a table which is the primary key and is an int. how do i make it also be auto_increment? the table already has some data in it, so i suspect that this may be where my problem comes from. when i use ALTER TABLE (my best guess at how to do it), i get this error: mysql> alter table fixtures modify column id int auto_increment; ERROR 1062: Duplicate entry '1' for key 1 perhaps i need to somehow start things up with the next highest auto increment .. or ...? thanks, -jon --------------------------------------------------------------------- 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