mysqlimport
Import data into MySQL server using command line
Supplementary instructions
mysqlimport command provides a command line data import tool for the mysql database server. It reads data from a text file in a specific format and inserts it into the MySQL database table.
grammar
mysqlimport(options)(parameters)Options
-D: Clear the table before importing data;
-f: Continue processing the remaining operations when an error occurs;
-h: The IP address or host name of the MySQL server;
-u: Username to connect to the MySQL server;
-p: Password to connect to the MySQL server.
