当前位置:Gxlcms > mysql > mysql学习笔记之帮助文档

mysql学习笔记之帮助文档

时间:2021-07-01 10:21:17 帮助过:11人阅读

查看系统帮助

help contents

  1. mysql> help contents;
  2. You asked for help about help category: "Contents"
  3. For more information, type 'help <item>', where <item> is one of the following
  4. categories:
  5. Account Management
  6. Administration
  7. Compound Statements
  8. Data Definition
  9. Data Manipulation
  10. Data Types
  11. Functions
  12. Functions and Modifiers for Use with GROUP BY
  13. Geographic Features
  14. Help Metadata
  15. Language Structure
  16. Plugins
  17. Procedures
  18. Storage Engines
  19. Table Maintenance
  20. Transactions
  21. User-Defined Functions
  22. Utility

帮助文档的目录列表

查看数据类型

help data types

  1. mysql> help data types;
  2. You asked for help about help category: "Data Types"
  3. For more information, type 'help <item>', where <item> is one of the following
  4. topics:
  5. AUTO_INCREMENT
  6. BIGINT
  7. BINARY
  8. BIT
  9. BLOB
  10. BLOB DATA TYPE
  11. BOOLEAN
  12. CHAR
  13. CHAR BYTE
  14. DATE
  15. DATETIME
  16. DEC
  17. DECIMAL
  18. DOUBLE
  19. DOUBLE PRECISION
  20. ENUM
  21. FLOAT
  22. INT
  23. INTEGER
  24. LONGBLOB
  25. LONGTEXT
  26. MEDIUMBLOB
  27. MEDIUMINT
  28. MEDIUMTEXT
  29. SET DATA TYPE
  30. SMALLINT
  31. TEXT
  32. TIME
  33. TIMESTAMP
  34. TINYBLOB
  35. TINYINT
  36. TINYTEXT
  37. VARBINARY
  38. VARCHAR
  39. YEAR DATA TYPE

查看整数

  1. mysql> help int;
  2. Name: 'INT'
  3. Description:
  4. INT[(M)] [UNSIGNED] [ZEROFILL]
  5. A normal-size integer. The signed range is -2147483648 to 2147483647.
  6. The unsigned range is 0 to 4294967295.
  7. URL: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html
  8. mysql> help tinyint;
  9. Name: 'TINYINT'
  10. Description:
  11. TINYINT[(M)] [UNSIGNED] [ZEROFILL]
  12. A very small integer. The signed range is -128 to 127. The unsigned
  13. range is 0 to 255.
  14. URL: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html

您可能感兴趣的文章:

  • 深入理解mysql帮助命令(help)
  • Mysql help命令(帮助信息)中文注解
  • MySQL性能优化的一些技巧帮助你的数据库

人气教程排行