How does the display width specification in MySQL INTEGER columns affect the stored values?

When specifying a display width for an INTEGER column in MySQL, it does not affect the storage size or range of values that can be stored. It only affects the display width when the integer is converted to a string for output. To ensure that the stored values are not affected by the display width specification, simply do not specify a display width for INTEGER columns. 

// Example of creating an INTEGER column in MySQL without specifying display width
$sql = "CREATE TABLE example_table (
        id INT
        )";

Keywords

MySQL INTEGER columns display width stored values PHP

Related Questions