List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 4 2001 8:47pm
Subject:RE: auto increment problems
View as plain text  
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
Thread
auto increment problemsAllen J. Schmidt4 Oct
  • RE: auto increment problemsWill French4 Oct
  • RE: auto increment problemsWill French4 Oct
RE: auto increment problemsAllen J. Schmidt4 Oct
RE: auto increment problemsPaul DuBois4 Oct