MySQL :: MySQL 9.0 参考手册 :: 6.5.1.4 mysql 客户端服务器端帮助

版本 9.0

8.4 当前
8.0
5.7

8.0 日语

MySQL 9.0 参考手册 / ... / mysql 客户端服务器端帮助

6.5.1.4 mysql 客户端服务器端帮助

Press CTRL+C to copy
 
mysql> help search_string

如果你为 help 命令提供参数，mysql 将使用它作为搜索字符串，从 MySQL 参考手册内容中访问服务器端帮助。此命令的正常运行需要在 mysql 数据库中初始化帮助表，其中包含帮助主题信息（参见第 7.1.17 节“服务器端帮助支持”）。

如果搜索字符串没有匹配项，搜索将失败。

Press CTRL+C to copy
 
mysql> help me

Nothing found
Please try to run 'help contents' for a list of all accessible topics

使用 help contents 查看帮助类别的列表。

Press CTRL+C to copy
 
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
   Data Definition
   Data Manipulation
   Data Types
   Functions
   Functions and Modifiers for Use with GROUP BY
   Geographic Features
   Language Structure
   Plugins
   Storage Engines
   Stored Routines
   Table Maintenance
   Transactions
   Triggers

如果搜索字符串匹配多个项目，mysql 将显示匹配主题的列表。

Press CTRL+C to copy
 
mysql> help logs
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:
   SHOW
   SHOW BINARY LOGS
   SHOW ENGINE
   SHOW LOGS

使用主题作为搜索字符串查看该主题的帮助条目。

Press CTRL+C to copy
 
mysql> help show binary logs
Name: 'SHOW BINARY LOGS'
Description:
Syntax:
SHOW BINARY LOGS

Lists the binary log files on the server. This statement is used as
part of the procedure described in [purge-binary-logs], that shows how
to determine which logs can be purged.

Press CTRL+C to copy
 
mysql> SHOW BINARY LOGS;
+---------------+-----------+-----------+
| Log_name      | File_size | Encrypted |
+---------------+-----------+-----------+
| binlog.000015 |    724935 | Yes       |
| binlog.000016 |    733481 | Yes       |
+---------------+-----------+-----------+

搜索字符串可以包含通配符 % 和 _。它们与使用 LIKE 运算符执行的模式匹配操作具有相同的含义。例如，HELP rep% 返回以 rep 开头的主题列表。

Press CTRL+C to copy
 
mysql> HELP rep%
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:
   REPAIR TABLE
   REPEAT FUNCTION
   REPEAT LOOP
   REPLACE
   REPLACE FUNCTION

上一个开始上级下一个