What is the maximum size of int(10) in Mysql
INT(10)
means you probably defined it as INT UNSIGNED
.
So, you can store numbers from 0
up to 4294967295
(note that the maximum value has 10 digits, so MySQL automatically added the (10)
in the column definition which (10) is just a format hint and nothing more. It has no effect on how big number you can store).
You can use BIGINT UNSIGNED
if you want to store bigger values. See the MySQL docs: Integer Types (Exact Value)
Just use BigInt Instead of Int in Mysqland if you want explanation in brief then goto