How to show the warnings during mysqlimport

How to show the warnings during mysqlimport

Answer:

When you use mysqlimport to import data from text file, the number of warnings will be displayed at the end of import. But there is no way to show the actual warnings message.

To show the warnings, the only method is get into the mysql client to insert, instead of using mysqlimport.

E.g.

mysql> LOAD DATA INFILE  '/tmp/user.csv' REPLACE INTO TABLE user
Query OK, 100000 rows affected, 192 warnings (2.30 sec)

mysql> SHOW WARNINGS;