when using the loading command
load data local infile '/home/kzhou/xxxy.data' into table mytable;
it will run to completion, after a long time, then telling me that 90%
of the rows are skipped.
load data local infile
'/home/kzhou/RUN_BLAST/pep2genome_ost9901.tbn.tab' into table
peptidetblne1000
-> ;
Query OK, 206876 rows affected (7 min 19.26 sec)
Records: 3700906 Deleted: 0 Skipped: 3494030 Warnings: 3700906
When I check the key constraints in my data, I found there is no
duplicated rows
in my input data.
How do I tell the parser to stop when seeing the first error? So that I
can figure what is wrong.
The man page for this function, does not seem to give any hint:
http://dev.mysql.com/doc/mysql/en/load-data.html
Kemin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
