List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 25 2003 12:23am
Subject:Re: URGENT: Auto increment suddenly not working?
View as plain text  
At 17:04 -0700 4/24/03, Erick Papadakis wrote:
>I have a problem with one of my tables. It is the default type  (MYISAM?)
>and has only 126 rows until now. I am stuck now at the 127th row. It just
>wont update the auto_increment field even when I MANUALLY insert the id
>as 129, it keeps telling me that a duplicate entry for 127 is found!!!
>Why is this? How can I fix it?

Change the column type from TINYINT to a larger integer type so that
it can hold values larger than 127.  AUTO_INCREMENT isn't a magic
way to expand the natural range of the underlying column type...

>The exact query
>INSERT INTO  ( `id` , `title`)
>VALUES ('129', 'This is my title');
>MySQL said:
>Duplicate entry '127' for key 1
>What's happening? This has been working all along...suddenly started not
>Thanks for any ideas,

Paul DuBois
sql, query
URGENT: Auto increment suddenly not working?Erick Papadakis25 Apr
  • Re: URGENT: Auto increment suddenly not working?Jocelyn Fournier25 Apr
  • Re: URGENT: Auto increment suddenly not working?Paul DuBois25 Apr