 | | | stop loading when error | stop loading when error 2005-09-10 - By Gleb Paharenko
Back
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 @@(protected)='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 @@(protected)='';
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 |
+---+
[gleb@(protected) mysql-debug-5.0.12-beta-linux-i686-glibc23]$ cat /tmp/a.txt
a
b
1
2
Kemin Zhou <kzhou@(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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@(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/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|