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

The following brings you about the methods of using mysql's own tools, if you are interested, let's take a look at this article. I believe it will be of some help to you after reading the methods of using mysql's own tools.

1) mysql command: mysql command is the most frequently used command tool, providing users with a command line interface to operate the CVM that manages MySQL.

Command format:

Usage:mysql [OPTIONS] [database]

Example: mysql-e "select user,host from user" mysql

Mysql-help can get the corresponding basic usage help information.

-e:-- execut=name: we are going to execute the commands after-e, but we do not enter the mysql interface through the mysql connection. This parameter is very useful in writing some basic mysql checking and monitoring scripts.

-E:-- vertical: all query results after login will be displayed in a column

-H,-- html,-X,--xml,: when these two parameters are enabled, all the results from select will be output in Html and Xml format

-- prompt=name: it is a very important parameter for operators, and its main function is to customize the display of their own mysql prompt. Personally, I strongly recommend:\\ u @\\ h:\\ d\\ r:\\ m:\\ s >

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.