mysql学习笔记之帮助文档

数据库  /  管理员 发布于 6年前   132

查看系统帮助

help contents

mysql> help contents;You asked for help about help category: "Contents"For more information, type 'help <item>', where <item> is one of the followingcategories:  Account Management  Administration  Compound Statements  Data Definition  Data Manipulation  Data Types  Functions  Functions and Modifiers for Use with GROUP BY  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 followingtopics:  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

查看整数

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: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.htmlmysql> help tinyint;Name: 'TINYINT'Description:TINYINT[(M)] [UNSIGNED] [ZEROFILL]A very small integer. The signed range is -128 to 127. The unsignedrange is 0 to 255.URL: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html