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:wfrench@stripped]
>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:aschmidt@stripped]
>> 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 <mysql-thread87105@stripped>
>> To unsubscribe, e-mail
>> <mysql-unsubscribe-wfrench=prevailnet.net@stripped>
>> 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 <mysql-thread87107@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-aschmidt=nv.cc.va.us@stripped>
>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 <mysql-thread87110@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Paul DuBois, paul@stripped
