Mysql help命令（帮助信息）中文注解(2)

--获取服务器管理相关的帮助，输入help contents
mysql> help 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

--要查询那一个部分的内容，直接输入help + 内容，如下
mysql> help administration;
You asked for help about help category: "Administration"
For more information, type 'help <item>', where <item> is one of the following
topics:
  BINLOG
  CACHE INDEX
  FLUSH
  FLUSH QUERY CACHE
  HELP COMMAND
  KILL
  ..........

--接下来，我们查看administration部分下的flush命令用法，直接输入help flush;即可
mysql> help flush;
Name: 'FLUSH'
Description:
Syntax:
FLUSH [NO_WRITE_TO_BINLOG | LOCAL]
  flush_option [, flush_option] ...

The FLUSH statement has several variant forms that clear or reload
various internal caches, flush tables, or acquire locks. To execute
FLUSH, you must have the RELOAD privilege. Specific flush options might
require additional privileges, as described later.   

--查看cache index的帮助信息
mysql> help CACHE INDEX;
Name: 'CACHE INDEX'
Description:
Syntax:
CACHE INDEX
 tbl_index_list [, tbl_index_list] ...
 [PARTITION (partition_list | ALL)]
 IN key_cache_name

tbl_index_list:
 tbl_name [[INDEX|KEY] (index_name[, index_name] ...)]

partition_list:
 partition_name[, partition_name][, ...]
 ........................

--总结，即通过逐级help的方式即可获得与其主题相关的详细信息。 --Author: Leshami --Blog: <a target="_blank" href="http://blog.csdn.net/leshami">http://blog.csdn.net/leshami

</a>--比较常用的show 命令，通常查看系统变量，状态变量等
mysql> help show;
Name: 'SHOW'
Description:
SHOW has many forms that provide information about databases, tables,
columns, or status information about the server. This section describes
those following:

SHOW AUTHORS
SHOW {BINARY | MASTER} LOGS

--设置系统变量，用set 命令
mysql> help set;
Name: 'SET'
Description:
Syntax:
SET variable_assignment [, variable_assignment] ...

variable_assignment:
   user_var_name = expr
  | [GLOBAL | SESSION] system_var_name = expr
  | [@@global. | @@session. | @@]system_var_name = expr

The SET statement assigns values to different types of variables that
affect the operation of the server or your client. Older versions of
MySQL employed SET OPTION, but this syntax is deprecated in favor of
SET without OPTION.

URL: http://dev.mysql.com/doc/refman/5.5/en/set-statement.html