At 2:05 PM -0400 10/4/01, Schmidt, Allen J. wrote: >I had read that somewhere before so the number was not a surprise when I saw >it. More it is a surprise why I cannot just simply add the field back in. I
You can. Or you could simply change its type to UNSIGNED and double the range of available values. It's always a good idea to make AUTO_INCREMENT columns UNSIGNED anyway, because they're not intended to hold negative numbers. >have been using mysqlfront on windows to do this and it has not been a >problem in the past. >I will try importing into a new table first. > >Thanks > > >-----Original Message----- >From: Will French [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 04, 2001 1:50 PM >To: MySQL >Subject: RE: auto increment problems > > >> 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 > >--------------------------------------------------------------------- >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 -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- 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
