> Error: 1062 - Duplicate entry '2147483647' for key 1 That number is the largest number which can be stored in a signed 32-bit (INT) field. As I rather doubt that your table contains > 2 billion rows, I am betting that your auto-numbers are starting at 1. My advice would be to create a new table and use "insert into" to populate all fields but the auto_increment field by specifying a column list. Additionally, you may find that myisamchk may have some feature to deal with this sort of problem but I don't recall.
Will > -----Original Message----- > From: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 1:34 PM > To: MySQL > Subject: auto increment problems > > > 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 > > --------------------------------------------------------------------- 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
