mysql help命令_Mysql命令行help

通过Mysql命令行登录后输入help命令即可看到如下消息：

mysql> help;

For information about MySQL products and services, visit:

http://www.mysql.com/

For developer information, including the MySQL Reference Manual, visit:

http://dev.mysql.com/

To buy MySQL Enterprise support, training, or other products, visit:

https://shop.mysql.com/

List of all MySQL commands:

Note that all text commands must be first on line and end with ';'

? (\?) Synonym for `help'.

功能同help，在命令行输入 ?; \?; 都可以显示help的内容

clear (\c) Clear the current input statement.

connect (\r) Reconnect to the server. Optional arguments are db and host.

重新连接Mysql并显示当前数据库

delimiter (\d) Set statement delimiter.

设置定界符

ego (\G) Send command to mysql server, display result vertically.

将查询结果垂直显示，如：执行查询select database() \G;显示结果为：

*************************** 1. row ***************************

database(): test

1 row in set (0.00 sec)

ERROR:

No query specified

exit (\q) Exit mysql. Same as quit.

退出Mysql

go (\g) Send command to mysql server.

help (\h) Display this help.

显示帮助

notee (\t) Don't write into outfile.

将记录不输出文件

print (\p) Print current command.

prompt (\R) Change your mysql prompt.

修改Mysql提示符

quit (\q) Quit mysql.

退出Mysql

rehash (\#) Rebuild completion hash.

source (\.) Execute an SQL script file. Takes a file name as an argument.

执行外部SQL文件

status (\s) Get status information from the server.

显示服务器状态

tee (\T) Set outfile [to_outfile]. Append everything into given outfile.

记录输出。如：执行tee output.txt; 后所有的记录都会记录在bin目录下的output.txt文件中

use (\u) Use another database. Takes database name as argument.

切换数据库

charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.

切换字符集

warnings (\W) Show warnings after every statement.

显示警告

nowarning (\w) Don't show warnings after every statement.

不显示警告

For server side help, type 'help contents'