IT Notes‎ > ‎Database‎ > ‎MySQL‎ > ‎

MySQL 的简要帮助

登录 MySQL 后,打一个问号即可得到简明的帮助。这里在系统的简明帮助后补充一些个人体会或故事。文中打三个问号的,表示还不会用。

mysql> ?

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'.
clear     (\c) Clear the current input statement. //经过鄙人的试验,这个命令似乎没有作用,OS 是 Windows 7
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. //所谓 delimiter,就是语句结束符号,如 Java 中的分号,mysql 中默认的 delimiter 也是分号,可以通过 delimiter + {char or string} 来改变结束符号,这主要用在写存储过程时,需要把分号换成别的符号。
ego       (\G) Send command to mysql server, display result vertically. //???
exit      (\q) Exit mysql. Same as quit. // 和按 Ctrl + C 一个效果
go        (\g) Send command to mysql server. //???
help      (\h) Display this help. //和问号一个意思
notee     (\t) Don't write into outfile. //这个命令是关闭 tee 的,具体要参看本页的 tee 命令
print     (\p) Print current command. //???
prompt    (\R) Change your mysql prompt. //???
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash. //???
source    (\.) Execute an SQL script file. Takes a file name as an argument. //执行一个 SQL 脚本文件,命令后跟 SQL 脚本文件路径。如 source /home/iridium/sql/hello.sql
status    (\s) Get status information from the server. //查看服务器信息,很好,包含数据库版本号,字符集等等。
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile. //将输出记录某文件,如 tee d:\hello.txt,会把所有的输出记录到 d:\hello.txt 里,通过 notee 可以关闭输出到文件。
use       (\u) Use another database. Takes database name as argument. //使用某个数据库,本命令后跟数据库名称。数据库名称可通过 show databases 获得。
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'



Comments