- Numeric Data Types
- TINYINT
- Tiny integer, -128 to 127 signed
- BOOLEAN
- Synonym for TINYINT(1)
- SMALLINT
- Small integer from -32768 to 32767 signed
- MEDIUMINT
- Medium integer from -8388608 to 8388607 signed
- INT
- Integer from -2147483648 to 2147483648 signed
- INTEGER
- Synonym for INT
- BIGINT
- Large integer
- DECIMAL
- A packed "exact" fixed-point number
- DEC, NUMERIC, FIXED
- Synonyms for DECIMAL
- FLOAT
- Single-precision floating-point number
- DOUBLE
- Normal-size (double-precision) floating-point number
- DOUBLE PRECISION
- REAL and DOUBLE PRECISION are are synonyms for DOUBLE
- BIT
- Bit field type
- Floating-point Accuracy
- Due to their nature, not all floating-point numbers can be stored with exac...
-
- String Data Types
- CHAR
- Fixed-length string
- VARCHAR
- Variable-length string
- BINARY
- Fixed-length binary byte string
- CHAR BYTE
- Alias for BINARY
- VARBINARY
- Variable-length binary byte string
- TINYBLOB
- Tiny binary large object up to 255 bytes
- BLOB
- Binary large object up to 65,535 bytes
- BLOB and TEXT Data Types
- Binary large object data types and the corresponding TEXT types
- MEDIUMBLOB
- Medium binary large object up to 16,777,215 bytes
- LONGBLOB
- Long BLOB holding up to 4GB
- TINYTEXT
- A TEXT column with a maximum length of 255 characters
- TEXT
- A TEXT column with a maximum length of 65,535 characters
- MEDIUMTEXT
- A TEXT column with a maximum length of 16,777,215 characters
- LONGTEXT
- A TEXT column with a maximum length of 4,294,967,295 characters
- ENUM
- Enumeration, or string object that can have one value chosen from a list of values
- SET Data Type
- Set, or string object that can have 0 or more values chosen from a list of values
-
-
- Date and Time Data Types
- DATE
- The date type YYYY-MM-DD
- TIME
- Time format HH:MM:SS.ssssss
- DATETIME
- Date and time combination displayed as YYYY-MM-DD HH:MM:SS
- TIMESTAMP
- YYYY-MM-DD HH:MM:DD
- YEAR Data Type
- A four-digit year
-
-
- Other Data Types Articles
- AUTO_INCREMENT
- Automatic increment
- Autoincrement FAQ
- NULL Values
- NULL represents an unknown value
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29070860/viewspace-1701923/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29070860/viewspace-1701923/