Press CTRL+C to copymysql> help search_string
如果您为该help
命令提供一个参数,mysql会将其用作搜索字符串以从 MySQL 参考手册的内容中访问服务器端帮助。此命令的正确操作需要mysql
使用帮助主题信息初始化数据库中的帮助表(请参阅
第 5.1.14 节,“服务器端帮助支持”)。
如果没有匹配搜索字符串,则搜索失败:
Press CTRL+C to copymysql> help me Nothing found Please try to run 'help contents' for a list of all accessible topics
使用帮助内容查看帮助类别列表:
Press CTRL+C to copymysql> 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 copymysql> 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 copymysql> help show binary logs Name: 'SHOW BINARY LOGS' Description: Syntax: SHOW BINARY LOGS SHOW MASTER 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 copymysql> SHOW BINARY LOGS; +---------------+-----------+ | Log_name | File_size | +---------------+-----------+ | binlog.000015 | 724935 | | binlog.000016 | 733481 | +---------------+-----------+
搜索字符串可以包含通配符
%
和_
。这些与使用运算符执行的模式匹配操作具有相同的含义LIKE
。例如,
HELP rep%
返回以 开头的主题列表rep
:
Press CTRL+C to copymysql> 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