Load data Warnings

Hi Experts,

I am using the LOAD DATA LOCAL INFILE command for my command prompt, and I am getting the following:

Query OK, 8448 rows affected, 65535 warnings (1.94 sec)
Records: 8448  Deleted: 0  Skipped: 0  Warnings: 84480
 
Basically, I have 10 warnings for every row. So my question is how/where can I see my warnings? I opened my server.err, but in there there are no warnings particular to my import.

Any help will be appreciated.
APD TorontoAsked:
Who is Participating?
 
Walter RitzelSenior Software EngineerCommented:
just type the command SHOW WARNINGS after your LOAD DATA have been executed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.