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.


 
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.

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



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



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



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.

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

Example: HELP 'status';

Resources 

Here are some useful related resources:

 

• Help and Show Commands in MySQL
  
• MySQL Transactions and Events
  
• Help Technique in Web applications
  
• Joins in MySQL
  
• Dispaly Data from MySQL 5.5.16 using ASP.NET 3.5