Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Oct 212010

How to show the warnings during mysqlimport


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.


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


 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>