MYSQL运维与分析--使用帮助help
来源:互联网 发布:企业网络搭建试题 编辑:程序博客网 时间:2024/06/05 19:46
使用?或help 后面跟你要查的命令
查看有哪些内容
mysql> ? contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
Account Management
Administration
Compound Statements
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUP BY
Geographic Features
Help Metadata
Language Structure
Plugins
Procedures
Storage Engines
Table Maintenance
Transactions
User-Defined Functions
Utility
mysql> ? Data Manipulation;
You asked for help about help category: "Data Manipulation"
For more information, type 'help <item>', where <item> is one of the following
topics:
CALL
DELETE
DO
DUAL
HANDLER
INSERT
INSERT DELAYED
INSERT SELECT
JOIN
LOAD DATA
LOAD XML
REPLACE
SELECT
UNION
UPDATE
查看具体的SQL
mysql> ? select
Name: 'SELECT'
Description:
Syntax:
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[PARTITION partition_list]
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
如果命令有歧义,也会有提示。
mysql> ? load
Many help items for your request exist.
To make a more specific request, please type 'help <item>',
where <item> is one of the following
topics:
LOAD DATA
LOAD INDEX
mysql> ? loda data
Nothing found
Please try to run 'help contents' for a list of all accessible topics
mysql> ? load data
Name: 'LOAD DATA'
Description:
Syntax:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[PARTITION (partition_name,...)]
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number {LINES | ROWS}]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
如果查看的命令不存在,则会报出来。
mysql> ? hello
Nothing found
Please try to run 'help contents' for a list of all accessible topics
- MYSQL运维与分析--使用帮助help
- Mysql 下帮助help或者help contests
- sipp -- help 参数与在线帮助
- VxWorks下使用帮助help出错
- SQLPLUS中HELP帮助的安装与删除
- mysql使用帮助
- mysql 帮助文档使用
- mysql帮助的使用
- mysql帮助的使用
- MySQL帮助的使用
- Mysql如何使用帮助
- 使用MySQL帮助
- Mysql帮助的使用
- mysql之帮助使用
- Tornado 2.2(vxworks5.5) Help 帮助无法使用的解决
- 使用HTML HELP WORKSHOP制作CHM帮助文档
- Search Help (搜索帮助)
- Get-Help 帮助信息
- CS231n作业笔记1.6:神经网络的误差与梯度计算
- Ubuntu下shadowsocks无法修改配置文件,立即卡死[已解决]
- win64 IDEA meaven 配置安装Thrift自动生成代码到目录
- docker 集群网络规划与 VM 网络配置
- 动画黄金搭档:CADisplayLink & CAShapeLayer
- MYSQL运维与分析--使用帮助help
- 数字排列
- 从零开始做远控 第五篇 屏幕监控
- ora-12545:因目标主机或对象不存在
- myeclipse 自定义视图Customize Perspective 没有反应
- Activity的生命周期及异常情况分析
- 证书算法
- https升级指南
- MySQL 5.6 for Windows 免安装版配置(mysql-5.6.34-winx64.zip)