I am sure this has been discussed but have not found specifically what I need.
I have a MyISAM table with an auto_increment primary key field. It sorta went nuts and started inserting strange new values. I decided to follow the stated procedures for resetting an auto_increment field by deleting and then readding the field. ALTER TABLE agents ADD column agent_dbid INT NOT NULL AUTO_INCREMENT PRIMARY KEY; But this has given a variety of errors. Here is the latest: Error: 1062 - Duplicate entry '2147483647' for key 1 I can provide other info if it would help but have not been using MySQL for long and am sorta stuck. Thanks Allen --------------------------------------------------------------------- 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
