List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 29 2001 1:13pm
Subject:Re: Loading Textfile into DB
View as plain text  
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 <mysql-thread78026@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Loading Textfile into DBDominic Brander29 Jun
  • Re: Loading Textfile into DBGerald Clark29 Jun
  • Re: Loading Textfile into DBDotCom29 Jun