Arnis Shinka Jr writes:
>
> So is there a place where MySQL stores all warning messages which occured
> during LOAD DATA ?
>
> -Arnis
No , there is not.
There is an item on our TODO for 4.* to optionally produce a table
with description of warnings. It is however not very high on TODO
li
So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
>
> Hi
>
> This is not a response to Malcolm, but rather a query.. if the CSV file
> to be imported into a MySQL table using LOAD DATA command had ASCII
> char(13) and/or ASCII char(10) in it, wo
Hi
This is not a response to Malcolm, but rather a query.. if the CSV file
to be imported into a MySQL table using LOAD DATA command had ASCII
char(13) and/or ASCII char(10) in it, would this interfere with the
usual behavior of LOAD DATA?
If so, is there a workaround for this problem? (In Oracl
I'm loading a large csv file and get the following result:
mysql> LOAD DATA LOCAL INFILE "kanji_all.csv" INTO TABLE kanji_all
-> FIELDS TERMINATED BY "," ENCLOSED BY "\"" IGNORE 1 LINES;
Query OK, 6355 rows affected (1.27 sec)
Records: 6355 Deleted: 0 Skipped: 0 Warnings: 49821
The resul
