- 工信部备案号 滇ICP备05000110号-1
- 滇公安备案 滇53010302000111
- 增值电信业务经营许可证 B1.B2-20181647、滇B1.B2-20190004
- 云南互联网协会理事单位
- 安全联盟认证网站身份V标记
- 域名注册服务机构许可:滇D3-20230001
- 代理域名注册服务机构:新网数码
? (?) 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.
--上面的所有命令,扩号内的为快捷操作,即只需要输入“”+ 字母即可执行
售前咨询
售后咨询
备案咨询
二维码
TOP