Shulou(Shulou.com)06/01 Report--

This article is about how to use the mysqlimport command in Linux. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Linux common command mysqlimport command provides a command-line tool for mysql database server to import data, which reads data from a text file in a specific format and inserts it into a MySQL database table.

Mysqlimport imports data from the command line for the MySQL server

Syntax mysqlimport (options) (parameters) option-D: clear the table before importing data;-f: continue to process the remaining operations if an error occurs;-ip address or hostname of the h:MySQL server;-u: user name to connect to the MySQL server;-p: password to connect to the MySQL server. Parameter database name: specify the name of the database to import

Text file: contains text files in a specific format.

Thank you for reading! This is the end of the article on "how to use mysqlimport commands in Linux". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.