unsigned integer size mysql code example
Example 1: unsigned int in mysql
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
Example 2: mysql size int
Type Storage (Bytes) Minimum Value Signed Minimum Value Unsigned Maximum Value Signed Maximum Value Unsigned
TINYINT 1 -128 0 127 255
SMALLINT 2 -32768 0 32767 65535
MEDIUMINT 3 -8388608 0 8388607 16777215
INT 4 -2147483648 0 2147483647 4294967295
BIGINT 8 -263 0 2^63-1 2^64-1