咨询热线:4006-75-4006
售前:9:00-23:30 备案:9:00-18:00 技术:7*24h
? (?) Synonym for `help'.
clear (c) Clear the current input statement. --清除当前输入的语句
connect ( ) Reconnect to the server. Optional arguments are db and host. --重新连接,通常用于被剔除或异常断开后重新连接
delimiter (d) Set statement delimiter. --设置命令终止符,缺省为;,比如我们可以设定为/来表示语句结束
edit (e) Edit command with $EDITOR. --编辑缓冲区的上一条SQL语句到文件,缺省调用vi,文件会放在/tmp路径下
ego (G) Send command to mysql server, display result vertically. --控制结果显示为垂直显示
exit (q) Exit mysql. Same as quit. --退出mysql
go (g) Send command to mysql server. --发送命令到mysql服务
help (h) Display this help.
nopager ( ) Disable pager, print to stdout. --关闭页设置,打印到标准输出
notee ( ) Don't write into outfile. --关闭输出到文件
pager (P) Set PAGER [to_pager]. Print the query results via PAGER. --设置pager方式,可以设置为调用more,less等等,主要是用于分页显示
print (p) Print current command.
prompt (R) Change your mysql prompt. --改变mysql的提示符
quit (q) Quit mysql.
rehash (#) Rebuild completion hash. --自动补齐相关对象名字
source (.) Execute an SQL script file. Takes a file name as an argument. --执行?本文件
status (s) Get status information from the server. --获得状态信息
system (!) Execute a system shell command. --执行系统命令
tee (T) Set outfile [to_outfile]. Append everything into given outfile. --操作结果输出到文件
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.
--上面的所有命令,扩号内的为快捷操作,即只需要输入“”+ 字母即可执行