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 OK, 0 rows affected (0.00 sec) mysql> load data infile '/tmp/a.txt' into table at; ERROR 1264 (22003): Out of range value adjusted for column 'a' at row 1 mysql> select * from at; Empty set (0.00 sec) mysql> set @@sql_mode=''; Query OK, 0 rows affected (0.00 sec) mysql> load data infile '/tmp/a.txt' into table at; Query OK, 4 rows affected, 2 warnings (0.00 sec) Records: 4 Deleted: 0 Skipped: 0 Warnings: 2 mysql> select * from at; +---+ | a | +---+ | 0 | | 0 | | 1 | | 2 | +---+ [EMAIL PROTECTED] mysql-debug-5.0.12-beta-linux-i686-glibc23]$ cat /tmp/a.txt a b 1 2 Kemin Zhou <[EMAIL PROTECTED]> wrote: > 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 > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
