Load Data - Succuess/Error information

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I'm using the MySQL "Load data" command to load big .csv files into a MySQL
database. Sometimes there are special characters within these .csv files
which cause some kind of "displacement" of the loaded data.

(1) Is there a way to check if the data from the .csv file was loaded
correctly ?

(2) I'd also like to know in which line an error occured.
The Oracle loader does this very well, but I need something similar for
MySQL, too!

I'm looking forward for you suggestions!

Thx, Mac

Site Timeline