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 mu
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
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 (