Re: Loading Textfile into DB

2001-06-29 Thread DotCom
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

Re: Loading Textfile into DB

2001-06-29 Thread Gerald Clark
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

Loading Textfile into DB

2001-06-29 Thread Dominic Brander
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 (