数据库常见的值类型

一、常用值类型

类型 大小 范围(有符号) 范围(无符号) 用途
varchar 0-65535 bytes 可变长文本字符串
int 1 Bytes (-128,127) (0,255) 小整数值
bigint 8 Bytes (-9223372036854775808,922337036854775807) (0,18446744073709551615) 极大整数值
float 4 Bytes (-3.402823466E+38,-1.175494351E-38),0,(1.175494351E-38,3.402823466351E+38) 0,(1.175494351E-38,3.402823466E+38) 单精度浮点数值
boolean true或false 逻辑运算

发表回复

Your email address will not be published. Required fields are marked *.

*
*