mysql 帮助文档使用
mysql有很完善的帮助文档,在mysql命令行下可以通过? 或者help 加上命令可以查看改命令的帮助信息,
我们查下几个常用的help命令
第一层帮助信息:
? contents;
mysql> ? Plugins;Name: 'SHOW PLUGINS'Description:Syntax:SHOW PLUGINSSHOW PLUGINS displays information about server plugins. Plugininformation is also available in the INFORMATION_SCHEMA.PLUGINS table.See http://dev.mysql.com/doc/refman/5.5/en/plugins-table.html.Example of SHOW PLUGINS output:mysql> SHOW PLUGINS\G*************************** 1. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINELibrary: NULLLicense: GPL*************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINELibrary: NULLLicense: GPL*************************** 3. row *************************** Name: MEMORY Status: ACTIVE Type: STORAGE ENGINELibrary: NULLLicense: GPL*************************** 4. row *************************** Name: MyISAM Status: ACTIVE Type: STORAGE ENGINELibrary: NULLLicense: GPL...URL: http://dev.mysql.com/doc/refman/5.5/en/show-plugins.htmlmysql> ? Transations;Nothing foundPlease try to run 'help contents' for a list of all accessible topicsmysql> ? Transactions;You asked for help about help category: "Transactions"For more information, type 'help <item>', where <item> is one of the followingtopics: ISOLATION LOCK SAVEPOINT START TRANSACTIONmysql>
通过帮助文档可以查询到mysql的所有命令及每个命令的功能,语法。