mysql Integer Types (Exact Value) – INTEGER, INT, SMALLINT,

mysql Integer Types (Exact Value) – INTEGER, INT, SMALLINT,

使用mysql的时候,用到int类型的蛮多,需要注意一下:1. 值的范围TypeStorageMinimum ValueMaximum Value(Bytes)(Signed/Unsigned)(Signed/Unsigned)TINYINT1-128127255SMALLINT2-327683276765535MEDIUMINT3-8388608838860716777215INT4-21474836482147483647