读书人

mysql 相助文档使用

发布时间: 2012-09-15 19:09:29 作者: rapoo

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的所有命令及每个命令的功能,语法。

读书人网 >Mysql

热点推荐