Help Statement in MYSQL Server


MySQL is a popular database management system, used as the data storage provider for thousands of web and server applications. MySQL server supports a help command that returns information from the MySQL. We can access server-side help in MYSQL and we can perform lookups in the MySQL server. This statement will provide the help to get started with MySQL.

abaa.gif
 
If we provide an argument for the help statement then the MYSQL server uses the help command as a search string for accessing the server-side help from the contents of the MySQL server. The purpose of this command requires the help tables in my MYSQL database.
When in MYSQL server if there is no match for the search string command, the search fails.

img 1.gif

Use help contents to see a list of the help categories.

img 2.gif

If the search string matches multiple items, MYSQL shows a list of matching topics.

img 5.gif

If the search string matches multiple items, MYSQL shows a list of matching topics.

img 3.gif

Use a topic as the search string to see the help entry for that topic and here to show the
lists of the binary log files on the server. This statement is used as part of the procedure, that shows how to determine which logs can be disposal.

img 4.gif

The argument to the HELP statement should yield a single-row result set containing a description for the named item.

Example: HELP 'status';

status.gif

Resources 

Here are some useful related resources:

Up Next
    Ebook Download
    View all
    Learn
    View all