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 <pbern@stripped>
> To: <mysql@stripped>
> 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:
> > <mysql-unsubscribe-patrick=coconet.com@stripped>
> >
> >
>
>
> --
> ---------------------------------------------------------------------
> 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:
> <mysql-unsubscribe-pbern=princeton.edu@stripped>
>
*****************************************************************
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
