· 8 years ago · Feb 16, 2018, 11:52 AM
1USE test;
2
3DROP TABLE IF EXISTS demo;
4CREATE TABLE IF NOT EXISTS demo (
5 id INT NOT NULL AUTO_INCREMENT,
6 demo TINYINT NOT NULL DEFAULT '0',
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9
10SHOW CREATE TABLE demo;
11
12INSERT INTO demo (demo) VALUES (127);
13INSERT INTO demo (demo) VALUES (12);
14INSERT INTO demo (demo) VALUES (1);
15
16SELECT * FROM demo;
17+----+------+
18| id | demo |
19+----+------+
20| 1 | 127 |
21| 2 | 12 |
22| 3 | 1 |
23+----+------+
24
25ALTER TABLE demo MODIFY demo TINYINT(3) ZEROFILL;
26
27+----+------+
28| id | demo |
29+----+------+
30| 1 | 127 |
31| 2 | 127 |
32| 3 | 012 |
33| 4 | 001 |
34+----+------+