List:General Discussion« Previous MessageNext Message »
From:Robert Trembath Date:October 19 2001 10:33pm
Subject:Problem doing bulk and regular inserts
View as plain text  
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 


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