mysql学习笔记之帮助文档
查看系统帮助
helpcontents
mysql>helpcontents; Youaskedforhelpabouthelpcategory:"Contents" Formoreinformation,type'help<item>',where<item>isoneofthefollowing categories: AccountManagement Administration CompoundStatements DataDefinition DataManipulation DataTypes Functions FunctionsandModifiersforUsewithGROUPBY GeographicFeatures HelpMetadata LanguageStructure Plugins Procedures StorageEngines TableMaintenance Transactions User-DefinedFunctions Utility
帮助文档的目录列表
查看数据类型
helpdatatypes
mysql>helpdatatypes; Youaskedforhelpabouthelpcategory:"DataTypes" Formoreinformation,type'help<item>',where<item>isoneofthefollowing topics: AUTO_INCREMENT BIGINT BINARY BIT BLOB BLOBDATATYPE BOOLEAN CHAR CHARBYTE DATE DATETIME DEC DECIMAL DOUBLE DOUBLEPRECISION ENUM FLOAT INT INTEGER LONGBLOB LONGTEXT MEDIUMBLOB MEDIUMINT MEDIUMTEXT SETDATATYPE SMALLINT TEXT TIME TIMESTAMP TINYBLOB TINYINT TINYTEXT VARBINARY VARCHAR YEARDATATYPE
查看整数
mysql>helpint; Name:'INT' Description: INT[(M)][UNSIGNED][ZEROFILL] Anormal-sizeinteger.Thesignedrangeis-2147483648to2147483647. Theunsignedrangeis0to4294967295. URL:http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html mysql>helptinyint; Name:'TINYINT' Description: TINYINT[(M)][UNSIGNED][ZEROFILL] Averysmallinteger.Thesignedrangeis-128to127.Theunsigned rangeis0to255. URL:http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html