int 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