maybe you got the id-field as tinyint??
----- Original Message -----
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 3:13 PM
Subject: Re: Loading Textfile into DB
> Right now, you pretty much have to compare the input to your loaded
> table and see which records are missing. Check the input file to see
> what is wrong with them.
>
>
>
> Dominic Brander wrote:
>
> > Hi
> >
> > I'm trying to load data from a tab deliminated textfile into my table
> > named blick_test:
> > load data local infile "public_html/DB2.txt" into table blick_test
> > ignore 1 lines;
> >
> > this works pretty fine, except I only get the first 256 records instead
> > of all 503!
> > message:
> > Query OK, 256 rows affected (0.01 sec)
> > Records: 503 Deleted: 0 Skipped: 247 Warnings: 741
> >
> > how can I turn on the warnings?
> > is there any limit in importing records from a textfile?
> >
> > thanks
> >
> > dominic
> >
> > ________________________________________________________________________
> > dominic brander - snowflake productions gmbh - http://www.snowflake.ch
> > 01 772 80 21
> >
> > ---------------------------------------------------------------------
> > 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> --
> Gerald L. Clark
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
