Difference between int(x) and mediumint(x) - MySQL

Difference between TinyInt / SmallInt / Med开发者_StackOverflow社区iumInt / Int / BigInt in MySQL data type ?

I want to use an [unsigned] integer field with 11 length, what should i use ?

[I'm using PHPMyAdmin]

Type            Range
TINYINT         -128 to 127<br>
SMALLINT        -32768 to 32767<br>
MEDIUMINT       -8388608 to 8388607<br>
INT             -2147483648 to 2147483647<br>
BIGINT          -9223372036854775808 to 9223372036854775807

You should use BIGINT.

Check the official documentation:

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html