类型 | 格式 | 占用字节 | 范围(L=值的长度) | 备注 | |
---|---|---|---|---|---|
整数类型 | TINYINT | (M) | 1 | 有符号: -128 ~ 127 无符号: 0 ~ 255 | 28(1个字节8位,下同) |
SMALLINT | (M) | 2 | 有符号: -32768 ~ 32767 无符号: 0 ~ 65535 | 216 | |
MEDIUMINT | (M) | 3 | 有符号: -223 ~ 223-1 无符号: 0 ~ 224 | M 表示显示宽度,配合“ ZEROFILL ”使用。 如果值不够M位时,用0在左边填充; 如果值超过M位,就按照实际位数存储 | |
INT | (M) | 4 | 有符号: -231 ~ 231-1 无符号: 0 ~ 232-1 | ||
BIGINT | (M) | 8 | 有符号: -263 ~ 263-1 无符号: 0 ~ 264 | ||
浮点类型 | FLOAT | (M,D) | 4 | 1<=M<=255, 0<=D<=30, D<=M | |
DOUBLE | (M,D) | 8 | 1<=M<=255, 0<=D<=30, D<=M | ||
定点类型 | DECIMAL | (M,D) | M+2 | 1<=M<=65, 0<=D<=30, D<= M | |
位类型 | BIT | (M) | M | ||
日期时间类型 | YEAR | 1 | 1901 ~ 2155 | ||
TIME | 3 | ||||
DATE | 3 | ||||
DATETIME | 8 | ||||
TIMESTAMP | 4 | ||||
字符串类型 | CHAR | (M) | M | 固定长度 | |
VARCHAR | (M) | M+1 | |||
TINYTEXT | L+2 | 0 <= L<= 255 | |||
TEXT | L+2 | 0 <= L<= 65535 | |||
MEDIUMTEXT | L+3 | 0 <= L<= 16777215 | |||
LONGTEXT | L+4 | 0 <= L<= 4294967295 | |||
枚举类型 | ENUM | 1,2 | 1 <= L <= 65535 | 1<= L <= 255 占1个字节 256<= L <= 65535 占2个字节 ENUM类型只允许从成员中选取单个值 | |
集合类型 | SET | 1,2,3,4,8 | 1 <= L <= 64 | 1 <= L <= 8 占1个字节 9 <= L <= 16 占2个字节 17 <= L <= 24 占3个字节 25 <= L <= 32 占4个字节 33 <= L <= 64 占8个字节 SET类型可以从成员中选取多个 | |
二进制类型 | BINARY | (M) | M | 0 <= M <= 255 | 固定长度 |
VARBINARY | (M) | M+1 | 0 <= M <= 65535 | ||
TINYBLOB | L+1 | 0 <= L<= 255 | |||
BLOB | L+2 | 0 <= L<= 65535 | |||
MEDIUMBLOB | L+3 | 0 <= L<= 16777215 | |||
LONGBLOB | L+4 | 0 <= L<= 4294967295 | |||
JSON类型 | JSON | MySQL >= 5.7 | |||
空间类型 | GEOMETRY | ||||
POINT | |||||
LINESTRING | |||||
POLYGON | |||||
MULTIPOINT | |||||
MULTILINESTRING | |||||
MULTIPOLYGON | |||||
GEOMETRYCOLLECTION |
MySql基本数据类型
于 2023-11-21 15:45:29 首次发布