mysql學習之幫助文檔詳解

本文給大家詳細講述的是mysql的help(幫助)命令的用法,非常細致,有需要的小伙伴可以來參考下

查看系統幫助

help contents

mysql&gt;?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  ??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</item></item>

幫助文檔的目錄列表

查看mysql

help data types

mysql&gt;?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</item></item>

查看mysql

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

? 版權聲明
THE END
喜歡就支持一下吧
點贊14 分享