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

This article introduces the relevant knowledge of "how to use the mysqlimport command of Linux". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

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.

Syntax format: mysqlimport [parameters]

Common parameters:-D clear the table before importing data-f continue to handle the remaining operations when there is an error-the ip address or hostname of the hMySQL server-u the user name of the connection MySQL server-p the password of the connection MySQL server uses the mysqlimport command to import data like the MySQL server, you need to pay attention to the encoding format of the file, otherwise it may lead to garbled imported data.

Refer to the instance and import the database:

[root@linux265 ~] # mysqlimport-u root-- local lxlinux.sql-- fields-terminated-by= "|" Import this article into the database:

[root@linux265 ~] # [root@linux265 ~] # mysqlimport-v-u root-p lxlinux_db lxlinux "how to use the mysqlimport command of Linux" ends here. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.