MySQL中整型长度的意义

DROP TABLE IF EXISTS `abc`;
CREATE TABLE IF NOT EXISTS `abc`
(
    `id` TINYINT(2)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
INSERT INTO abc(id) VALUE (1);
INSERT INTO abc(id) VALUE (11);
INSERT INTO abc(id) VALUE (111);
SELECT * FROM abc;

1
11
111

DROP TABLE IF EXISTS `abc`;
CREATE TABLE IF NOT EXISTS `abc`
(
    `id` TINYINT(2) ZEROFILL
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
INSERT INTO abc(id) VALUE (1);
INSERT INTO abc(id) VALUE (11);
INSERT INTO abc(id) VALUE (111);
SELECT * FROM abc;

01
11
111