MySQL client server help

Let's learn about MySQL Client-Server-Side Help-

mysql> help search_string

If an argument is provided to the above "help" command, mysql will use it as a search String to access server-side help in the MySQL Reference Manual content. Correct operation of this command requires initializing the help tables in the mysql database with help topic information.

If the search string does not match, the search operation fails. Let us take an example to understand this -

mysql> help me

Output

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

We can use the help content command to view the list of help categories. Let us take an example to understand this -

mysql> help contents

Output

You asked for help about help category: "Contents"
For more information, type &#39;help <item>&#39;, 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

If the search string matches multiple items, then mysql will display a list of matching topics. Let us take an example to understand this -

mysql > help logs

output

Many help items for your request exist.
To make a more specific request, please type &#39;help <item>&#39;,
where <item> is one of the following topics:
   SHOW
   SHOW BINARY LOGS
   SHOW ENGINE
   SHOW LOGS

The above is the detailed content of MySQL client server help. For more information, please follow other related articles on the PHP Chinese website!