?     (?) Synonym for `help'.

clear   (c) Clear the current input statement.  --清除當(dāng)前輸入的語(yǔ)句

connect  ( ) Reconnect to the server. Optional arguments are db and host.  --重新連接，通常用于被剔除或異常斷開(kāi)后重新連接

delimiter (d) Set statement delimiter.  --設(shè)置命令終止符，缺省為；，比如我們可以設(shè)定為/來(lái)表示語(yǔ)句結(jié)束 

edit   (e) Edit command with $EDITOR.  --編輯緩沖區(qū)的上一條SQL語(yǔ)句到文件，缺省調(diào)用vi，文件會(huì)放在/tmp路徑下

ego    (G) Send command to mysql server, display result vertically.  --控制結(jié)果顯示為垂直顯示

exit   (q) Exit mysql. Same as quit.  --退出mysql

go    (g) Send command to mysql server.  --發(fā)送命令到mysql服務(wù)

help   (h) Display this help.

nopager  ( ) Disable pager, print to stdout.  --關(guān)閉頁(yè)設(shè)置，打印到標(biāo)準(zhǔn)輸出  

notee   ( ) Don't write into outfile.  --關(guān)閉輸出到文件

pager   (P) Set PAGER [to_pager]. Print the query results via PAGER.  --設(shè)置pager方式，可以設(shè)置為調(diào)用more,less等等，主要是用于分頁(yè)顯示

print   (p) Print current command.           

prompt  (R) Change your mysql prompt.  --改變mysql的提示符 

quit   (q) Quit mysql.                             

rehash  (#) Rebuild completion hash.  --自動(dòng)補(bǔ)齊相關(guān)對(duì)象名字  

source  (.) Execute an SQL script file. Takes a file name as an argument.  --執(zhí)行?本文件

status  (s) Get status information from the server.  --獲得狀態(tài)信息

system  (!) Execute a system shell command.  --執(zhí)行系統(tǒng)命令   

tee    (T) Set outfile [to_outfile]. Append everything into given outfile.  --操作結(jié)果輸出到文件 

use    (u) Use another database. Takes database name as argument.  --切換數(shù)據(jù)庫(kù)

charset  (C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.  --設(shè)置字符集

warnings (W) Show warnings after every statement.  --打印警告信息

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

--上面的所有命令，擴(kuò)號(hào)內(nèi)的為快捷操作，即只需要輸入“”+ 字母即可執(zhí)行