How To Get Help Information From The Server

How To Get Help Information From The Server


  • 30 Jan, 2012

    While you are at the "mysql>" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows several examples:>cd mysql in>mysql -u rootmysql> HELP;...List of all MySQL commands:Note that all text commands must be end with ';'? (?) Synonym for `help'.clear (c) Clear command.connect () Reconnect to the server. ...mysql> HELP SHOW;Name: 'SHOW'Description:SHOW has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following:SHOW CREATE DATABASE db_nameSHOW CREATE FUNCTION funcnameSHOW CREATE PROCEDURE procnameSHOW CREATE TABLE tbl_nameSHOW DATABASES [LIKE 'pattern']SHOW ENGINE engine_name {LOGS | STATUS }...mysql> HELP CREATE TABLE;Name: 'CREATE TABLE'Description:Syntax:CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_option ...]...

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.