From: Paul H. Bern Date: February 15 2000 4:31pm Subject: Re: Phantom repeating ID List-Archive: http://lists.mysql.com/mysql/27847 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 15 Feb 2000, Pat Sherrill wrote: That did the trick! Nothing like paying attention to the manual! Now I know why I have that quote on my .sig line. ;-) Thanks all! > Paul, > > What is the type of field for your ID field. You probably need to increase > the size/type of your first field. Your hitting a 32k limit for signed > integers on some systems. > > Pat... > > ----- Original Message ----- > From: Paul H. Bern > To: > Sent: Tuesday, February 15, 2000 11:00 AM > Subject: Phantom repeating ID > > > > > > Hi All, > > > > I have a really strange (to me anyhow) problem. I'm trying to load a > > tab-delimited file with 11 fields and 42,793 records. The first field is > > a non-unique ID and the source of my problem. The file appears to load > > correctly, except that starting with the 12,793rd record, the ID field > > repeats the same number (32767 - the ID has nothing to do with the record > > number) for the rest of the file. Interestingly enough, this ID does not > > actually appear in the data, and the last good record has an ID=32766. I > > cleaned out all "/", "\", "&" from the file and still had the same > > problem. I even tried sorting the input file on a different field before > > loading it and still got the repeating 32767 - on the same exact records > > as before rather than at the 12,793rd, as though I had simply sorted the > > previous table. > > > > Any ideas? > > > > > > > > Thanks! > > > > Paul > > > > ***************************************************************** > > Paul H. Bern The only thing worse than > > Data and Statistical Services not getting what you wanted > > Princeton University is getting what you asked for > > (609) 258-6053 > > > > > > -- > > --------------------------------------------------------------------- > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > > posting. To request this thread, e-mail mysql-thread27837@stripped > > > > To unsubscribe, send a message to: > > > > > > > > > -- > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > posting. To request this thread, e-mail mysql-thread27842@stripped > > To unsubscribe, send a message to: > > ***************************************************************** Paul H. Bern The only thing worse than Data and Statistical Services not getting what you wanted Princeton University is getting what you asked for (609) 258-6053