HELP 查询内容
其中,查询内容为要查询的关键字。HELP 'rep%'
用来返回以 rep 开头的主题列表。mysql> HELP'contents'; You asked for help about help category: "Contents" For more information, type 'help <item>', where <item> is one of the following categories: Account Management Administration Compound Statements Contents Data Definition Data Manipulation Data Types Functions Geographic Features Help Metadata Language Structure Plugins Procedures Storage Engines Table Maintenance Transactions User-Defined Functions Utility
HELP Data Types;
命令查看所支持的数据类型,运行结果如下:mysql> HELP 'Data Types'; You asked for help about help category: "Data Types" For more information, type 'help <item>', where <item> is one of the following topics: AUTO_INCREMENT BIGINT BINARY BIT BLOB BLOB DATA TYPE BOOLEAN CHAR CHAR BYTE DATE DATETIME DEC DECIMAL DOUBLE DOUBLE PRECISION ENUM FLOAT INT INTEGER LONGBLOB LONGTEXT MEDIUMBLOB MEDIUMINT MEDIUMTEXT SET DATA TYPE SMALLINT TEXT TIME TIMESTAMP TINYBLOB TINYINT TINYTEXT VARBINARY VARCHAR YEAR DATA TYPE如果还想进一步查看某一数据类型,如 INT 类型,可以使用
HELP INT;
命令,运行结果如下:mysql> HELP 'INT'; Name: 'INT' Description: INT[(M)] [UNSIGNED] [ZEROFILL] A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295. URL: https://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html运行结果中可以看到 INT 类型的帮助信息,包含类型描述、取值范围和官方手册中 INT 类型说明的 URL。
HELP CREATE TABLE
命令查询创建数据表的语法,运行结果如下所示:mysql> HELP 'CREATE TABLE' Name: 'CREATE TABLE' Description: Syntax: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options] CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [partition_options] [IGNORE | REPLACE] [AS] query_expression
本文链接:http://task.lmcjl.com/news/13316.html