List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 15 2001 1:01pm
Subject:Re: Can only create 127 records in a table :o(
View as plain text  
How many positive integers do you expect a tinyint to hold?
Change it to an int or greater, and your problem should disappear.

You realize, though, that this is pure conjecture, since you did not
supply any information.


Mette Møller Madsen wrote:

> Hi there!
> 
> When I try to insert more than 127 rows/records in a table I get this error:
> 
> ERROR 1062: Duplicate entry '127' for key 1
> (the key is an auto incremented primary key)
> 
> Does anyone know how to store _more_ than 127 rows in a table?
> 
> My guess is that I need to change to settings of my db, but I cannot find
> anything in the manual. (I'm running version 3.23.38 which should be a
> stable one.)
> 
> best regards,
> Mette Madsen
> 
> 
> ---------------------------------------------------------------------
> 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-thread76695@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Can only create 127 records in a table :o(Mette Møller Madsen15 Jun
  • RE: Can only create 127 records in a table :o( Cabesa )15 Jun
  • RE: Can only create 127 records in a table :o(Bruce Stewart15 Jun
    • RE: Can only create 127 records in a table :o(Bill \"Elvis\" Gibbs15 Jun
  • ODP: Can only create 127 records in a table :o(Daniel Las15 Jun
  • Re: Can only create 127 records in a table :o(Rafal Jank15 Jun
  • Re: Can only create 127 records in a table :o(Pat Sherrill15 Jun
  • Re: Can only create 127 records in a table :o(Gerald Clark15 Jun
  • Re: Can only create 127 records in a table :o(Thomas Karcher15 Jun
  • Re: Can only create 127 records in a table :o(Alexander Skwar15 Jun
RE: Can only create 127 records in a table :o(Jon Haworth15 Jun