MySQL常用命令使用
来源:互联网 发布:libreoffice知乎 编辑:程序博客网 时间:2024/06/01 08:27
List of all MySQL commands:
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
notee (\t) Don't write into outfile.
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.
status (\s) Get status information from the server.
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.
resetconnection(\x) Clean session context.
Note that all text commands must be first on line and end with ';'
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
notee (\t) Don't write into outfile.
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.
status (\s) Get status information from the server.
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.
resetconnection(\x) Clean session context.
0 0
- Mysql常用命令使用
- MySQL 使用 常用命令
- MySQL 常用命令的使用
- MySQL 常用命令的使用
- MySql使用常用命令
- MySQL 常用命令的使用
- MySQL常用命令使用
- mysql常用命令以及使用tip
- MySQL常用命令--show命令使用
- MySQL常用命令--create命令使用
- MySQL安装使用和常用命令
- MySql常用命令解释及使用示例
- Mysql安装过程--使用源码安装 & 常用命令
- Mysql常用命令详解;做参考文档使用
- MySQL常用命令
- MySql常用命令
- MySQL常用命令
- mysql常用命令
- Spark编写UDAF自定义函数(JAVA)
- 串口驱动程序设计详解---串口打开、发送、接收(下)
- thinkphp调用二级栏目(二级分类) 函数+模板 完整代码
- Mac安装mongodb及其php扩展
- jquerydemo夜间模式,白天模式
- MySQL常用命令使用
- Spring Boot中使用@Async实现异步调用
- centos系统安装TensorFlow
- 哈夫曼树
- 设计模式-单例模式
- Struts2返回JSON数据的具体应用范例
- HTML5基础加强css样式篇(css属性transform 函数(2D)时钟)(二十六)
- js鼠标控制div缩放移动
- 大数据--sqoop/hive搭建