Geek asks and answers

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

Difference between TinyInt / SmallInt / MediumInt / Int / BigInt in MySQL data type?
I want to use an integer [unsigned] with a length of 11, what should I use?

[I am using PHPMyAdmin]

+3
source share
2 answers
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 must use BIGINT.

+6
source

Check out the official documentation:

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

0
source

More articles:


All Articles