Imanez Imanez - 1 year ago 127
MySQL Question

Numeric column with dynamic row format in MySQL

If I have a MyISAM table with Dynamic as row format, are the numeric columns (int(11), bigint(12)..) dynamic or static columns?

For example, if I have int(11) as the column type but the maximum value for this column is 1234, in this case does this column use only the space required which is int(4) or does it use the space like int(11)?

Answer Source

The length just specifies how many characters to display when selecting data with the mysql command line client.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download