Hello.
Maybe STRICT_ALL_TABLES sql mode is that you want? See:
http://dev.mysql.com/doc/mysql/en/server-sql-mode.html
Use 'SHOW WARNINGS' to find out the problems. See:
http://dev.mysql.com/doc/mysql/en/show-warnings.html
Example:
mysql> set @@sql_mode='STRICT_ALL_TABLES';
Query
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
peptidetblne