SIGN UP MEMBER LOGIN:    
ARTICLE

Help Statement in MYSQL Server

Posted by Arjun Panwar Articles | Databases & DBA January 02, 2012
This article explains the help statement which provides a list of help categories.
Reader Level:

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:

Login to add your contents and source code to this article
share this article :
post comment
 
Nevron Gauge for SharePoint
Become a Sponsor
PREMIUM SPONSORS
  • Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
    Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!
Nevron Gauge for SharePoint
Become a Sponsor