Data Types in MariaDB10

1. Numeric Data Types
   
2. TINYINT
   
3. Tiny integer, -128 to 127 signed
   
4. BOOLEAN
   
5. Synonym for TINYINT(1)
   
6. SMALLINT
   
7. Small integer from -32768 to 32767 signed
   
8. MEDIUMINT
   
9. Medium integer from -8388608 to 8388607 signed
   
10. INT
    
11. Integer from -2147483648 to 2147483648 signed
    
12. INTEGER
    
13. Synonym for INT
    
14. BIGINT
    
15. Large integer
    
16. DECIMAL
    
17. A packed "exact" fixed-point number
    
18. DEC, NUMERIC, FIXED
    
19. Synonyms for DECIMAL
    
20. FLOAT
    
21. Single-precision floating-point number
    
22. DOUBLE
    
23. Normal-size (double-precision) floating-point number
    
24. DOUBLE PRECISION
    
25. REAL and DOUBLE PRECISION are are synonyms for DOUBLE
    
26. BIT
    
27. Bit field type
    
28. Floating-point Accuracy
    
29. Due to their nature, not all floating-point numbers can be stored with exac...
    
30. 
    
31. String Data Types
    
32. CHAR
    
33. Fixed-length string
    
34. VARCHAR
    
35. Variable-length string
    
36. BINARY
    
37. Fixed-length binary byte string
    
38. CHAR BYTE
    
39. Alias for BINARY
    
40. VARBINARY
    
41. Variable-length binary byte string
    
42. TINYBLOB
    
43. Tiny binary large object up to 255 bytes
    
44. BLOB
    
45. Binary large object up to 65,535 bytes
    
46. BLOB and TEXT Data Types
    
47. Binary large object data types and the corresponding TEXT types
    
48. MEDIUMBLOB
    
49. Medium binary large object up to 16,777,215 bytes
    
50. LONGBLOB
    
51. Long BLOB holding up to 4GB
    
52. TINYTEXT
    
53. A TEXT column with a maximum length of 255 characters
    
54. TEXT
    
55. A TEXT column with a maximum length of 65,535 characters
    
56. MEDIUMTEXT
    
57. A TEXT column with a maximum length of 16,777,215 characters
    
58. LONGTEXT
    
59. A TEXT column with a maximum length of 4,294,967,295 characters
    
60. ENUM
    
61. Enumeration, or string object that can have one value chosen from a list of values
    
62. SET Data Type
    
63. Set, or string object that can have 0 or more values chosen from a list of values
    
64. 
    
65. 
    
66. Date and Time Data Types
    
67. DATE
    
68. The date type YYYY-MM-DD
    
69. TIME
    
70. Time format HH:MM:SS.ssssss
    
71. DATETIME
    
72. Date and time combination displayed as YYYY-MM-DD HH:MM:SS
    
73. TIMESTAMP
    
74. YYYY-MM-DD HH:MM:DD
    
75. YEAR Data Type
    
76. A four-digit year
    
77. 
    
78. 
    
79. Other Data Types Articles
    
80. AUTO_INCREMENT
    
81. Automatic increment
    
82. Autoincrement FAQ
    
83. NULL Values
    
84. NULL represents an unknown value

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29070860/viewspace-1701923/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29070860/viewspace-1701923/