下面讲讲关于mysql如何查看配置参数和获取帮助,文字的奥妙在于贴近主题相关。所以,闲话就不谈了,我们直接看下文吧,相信看完mysql如何查看配置参数和获取帮助这篇文章你一定会有所受益。
查看配置参数:
SHOW VARIABLES LIKE '%timeout%'
2)MySQL客户端工具自带的帮助
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement. –清除当前输入的语句
connect (\r) 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 (\n) Disable pager, print to stdout. –关闭页设置,打印到标准输出
notee (\t) 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.
3、服务端的相关帮助
–获取云服务器管理相关的帮助,输入help contents
mysql> help contents;
对于以上mysql如何查看配置参数和获取帮助相关内容,大家还有什么不明白的地方吗?或者想要了解更多相关,可以继续关注我们的行业资讯板块。