List:General Discussion« Previous MessageNext Message »
From:Steve Meyers Date:October 19 2001 10:46pm
Subject:RE: Problem doing bulk and regular inserts
View as plain text  
You haven't given your table definition, but I'm guessing that your primary key is a
TINYINT, which only supports -128 to +127.  Figure out how big you need that key to be,
then change the column as appropriate to a SMALLINT, MEDIUMINT, INT, or BIGINT.
 
Steve Meyers


> -----Original Message-----
> From: Robert Trembath [mailto:robert@stripped]
> Sent: Friday, October 19, 2001 4:34 PM
> To: mysql@stripped
> Subject: Problem doing bulk and regular inserts
> 
> 
> I have some nice database for a biotech lab running on the windows
> version of mysql 3.23 on a W2K server. For some reason when my ID or
> Auto-increment field get to 127 I can't insert any additional records. I
> get the following error:
> 
> Error 
> SQL-query :  [Edit] 
> 
> insert into curvesdb (Genus, Species, Strain, SampleID, BNID, Primer,
> LaneNo, CurveData, DCD_Name) VALUES('Xanthomonas', ' bromi', '', 'LMG
> 8269', '01-052-0094', 'Uprime-B1', '440-442-46',
> '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
> ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,2,2,1,1,0,0
> ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,2,2,2,2,2,2,2,1,1,1,1,1,1,1,1,1
> ,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,5,7,9,10,10,9,8,6,5,3,1,0,0,0,0
> ,0,0,0,0,0,0,0,0,0,0,0,0,1,2,4,5,6,6,6,6,5,5,5,5,5,5,5,5,5,4,3,2,1,1,0,0
> ,0,0,0,0,0,0,1,2,2,3,4,5,5,4,2,1,1,1,4,7,13,20,25,31,34,34,33,27,22,15,9
> ,5,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,2,4,6,8,9,9,9,7,5,3,1,0,0,0,0,1,1
> ,1,1,0,0,0,0,0,1,5,12,19,28,36,41,46,44,41,34,25,17,9,3,1,0,0,0,0,0,0,1,
> 2,4,6,10,13,17,20,23,25,25,23,22,18,14,10,6,4,2,2,3,4,5,6,6,6,4,3,2,1,1,
> 1,2,2,3,3,3,1,0,0,0,0,1,3,10,18,27,37,43,47,49,45,41,36,31,34,38,47,59,7
> 1,83,93,92,91,80,66,52,36,21,12,4,3,3,4,6,7,7,6,4,3,1,0,0,0,0,0,0,0,0,0,
> 0,1,1,2,3,4,5,6,9,13,19,28,36,46,56,62,68,68,64,58,47,36,24,12,6,1,0,0,0
> ,2,4,4,4,4,4,3,2,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,2,4,8,12,15,19,22,22,
> 22,20,17,14,11,8,6,3,3,3,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,5,7,9,10,10
> ,10,9,8,7,7,6,6,6,6,7,8,10,14,18,29,43,59,81,102,123,144,154,162,159,148
> ,134,110,87,64,41,26,14,5,2,0,1,3,4,6,6,6,6,5,5,5,5,5,5,5,5,5,4,3,2,1,0,
> 0,0,0,0,3,8,15,26,37,47,58,64,67,68,61,53,42,30,20,11,5,3,1,1,2,3,3,3,2,
> 1,1,0,0,0,0,0,0,0,0,1,4,7,9,12,12,13,13,13,13,13,13,15,17,21,25,27,29,29
> ,26,24,19,14,9,5,1,0,0,0,0,0,2,3,4,6,6,7,7,7,6,5,3,2,1,0,0,0,0,0,0,0,1,2
> ,3,3,2,2,2,1,1,1,1,1,3,4,8,12,16,20,24,25,26,25,22,19,14,10,6,2,1,0,0,0,
> 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,2,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,
> 0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,2,3,4,4,5,6,7,7,6,5,4,3,2,1,0,0,0,0,
> 0,0,0,0,0,1,1,1,1,1,2,2,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,2,3,3,3,4,4,6,
> 9,14,19,26,35,44,53,63,69,74,75,72,68,59,50,39,29,21,15,11,9,8,8,8,9,9,8
> ,7,6,5,3,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
> ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,1
> ,1,1,1,1,0,', 'Xanthomonas-B1')
> 
> MySQL said: 
> 
> 
> Duplicate entry '127' for key 1
> 
> I can not insert any more data to this table. This is an important
> issue, please help me to resolve this.
> 
> --------------------------
> Robert Trembath
> Internet Technology Manager
> e|robert@stripped 
> 
> 
> 
> ---------------------------------------------------------------------
> 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-thread88467@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-steve-mysql-mainlist=spamaphobia.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


Thread
Problem doing bulk and regular insertsRobert Trembath20 Oct
  • Re: Problem doing bulk and regular insertsVan20 Oct
  • Re: Problem doing bulk and regular insertsDan Nelson20 Oct
  • Re: Problem doing bulk and regular insertsMichael20 Oct
  • RE: Problem doing bulk and regular insertsSteve Meyers20 Oct