MySQL 1.00 数据类型

> 数据类型

# 数字
|    类型    |  大小   |                    范围                      | 
|------------|---------|----------------------------------------------|
|TINYINT     | 1 Bytes |-128，127                                     |
|SMALLINT    | 2 Bytes |-32768，32767                                 |
|MEDIUMINT   | 3 Bytes |-8388608，8388607                             |
|INT         | 4 Bytes |-2147483648，2147483647                       |
|BIGINT      | 8 Bytes |-9223372036854775808，9223372036854775807     |
|FLOAT 	     | 4 Bytes |-3.402823466 E+38~-1.175494351 E-38,0,1.175494351 E-38~3.402823466351 E+38|
|DOUBLE      | 8 Bytes |-1.7976931348623157 E+308~-2.2250738585072014 E-308,0,2.2250738585072014 E-308~1.7976931348623157 E+308| 
|DECIMAL(M,D)| 	MAX(M+2,D+2) | |

# 字符串类型
|    类型    |       大小        |
|------------|-------------------|
|CHAR(n) 	 |0-255 bytes        |
|VARCHAR(n)  |0-65535 bytes      |
|TINYBLOB 	 |0-255 bytes        |
|TINYTEXT 	 |0-255 bytes        |
|BLOB 	     |0-65535 bytes      |
|TEXT 	     |0-65535 bytes      |
|MEDIUMBLOB  |0-16777215 bytes 	 |
|MEDIUMTEXT  |0-16777215 bytes 	 |
|LONGBLOB 	 |0-4294967295 bytes |
|LONGTEXT 	 |0-4294967295 bytes |

# 日期时间
|    类型    |  大小   |                      范围                        |         格式         | 
|------------|---------|--------------------------------------------------|----------------------|
|DATE 	     |3 bytes  |1000-01-01～9999-12-31    	                      |YYYY-MM-DD            |
|TIME 	     |3 bytes  |-838:59:59～838:59:59                             |HH:MM:SS              |
|YEAR 	     |1 bytes  |1901～2155 	                                      |YYYY                  |
|DATETIME 	 |8 bytes  |1000-01-01 00:00:00～9999-12-31 23:59:59          |YYYY-MM-DD hh:mm:ss 	 |
|TIMESTAMP 	 |4 bytes  |1970-01-01 00:00:01 UTC ～ 2038-01-19 03:14:07 UTC|YYYY-MM-DD hh:mm:ss   |

# 其它
```
属性名 ENUM ('值1','值2'...)     #只能选一个
属性名  SET ('值1','值2'...)     #可取1到多个元素
```

乱读天书， 不求甚解

乱读天书，不求甚解