让我们了解MySQL客户端-服务器端的帮助-
mysql> help search_string
如果上面的“ help”命令提供了一个参数,则mysql将使用它作为搜索字符串,以从《 MySQL参考手册》的内容访问服务器端帮助。要正确执行此命令,需要使用帮助主题信息初始化mysql数据库中的帮助表。
如果搜索字符串不匹配,则搜索操作将失败。让我们以一个例子来理解这一点-
mysql> help me输出结果
Nothing found Please try to run 'help contents' for a list of all accessible topics
我们可以使用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 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将显示匹配主题的列表。让我们以一个例子来理解这一点-
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