sql变量取值范围

bigint

-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

18446744073709551615

8 Bytes

int

-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

4294967295

4 Bytes

mediumint

-2^23 (-8,388,608) to 2^23-1 (8,388,607)

16777215

3 Bytes

smallint

-2^15 (-32,768) to 2^15-1 (32,767)

65535

2 Bytes

tinyint

0 to 255

1 Byte