What's the difference between the following data types, as the maximum number of digits can be specified in the size parameter of all of them?
int(size)
smallint(size)
tinyint(size)
mediumint(size)
bigint(size)
Read the MySQL manual on data types.