MySQL integer type description int (5) vs Int (7)

It suddenly dawned on me today that 1 of the Int (1) and tinyint (1) in MySQL only specify the display length, not the storage length, only useful if the field specifies Zerofill. The limit of the digits is basically meaningless.

Int (5) Here 5 represents the shortest display of 5 characters. Int (7) Here 7 represents the shortest display of 7 characters. When the length of the inserted character exceeds (m), it is equivalent to nothing; when the character length is less than (m), it is necessary to specify a character to fill, such as zerofill (denoted with 0 padding).

such as int (5), insert data is 1234, if not filled 0, the display is 1234, fill 0, display is 01234

MySQL integer type description int (5) vs Int (7)