資料型態 | 佔用之bytes | 數值範圍 |
tinyint tinyint unsigned smallint smallint unsigned integer integer unsigned bigint bigint unsigned float double |
1 byte 1 byte 2 bytes 2 bytes 4 bytes 4 bytes 8 bytes 8 bytes 4 bytes 8 bytes |
-128~127 0~255 -32768~32767 0~65535 -2147483648~2147483647 0~4294967295 -9.2E+18~9.2E+18(約) 0~1.8E+19(約) -3.4E+38~3.4e+38(約) -1.79E+308~1.79E+308(約) |