mysql> CREATE TABLE example_table (
-> id INT(5) ZEROFILL,
-> name VARCHAR(50)
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> insert into example_table values(1,"张三");
Query OK, 1 row affected (0.01 sec)
mysql> select * from example_table;
+-------+--------+
| id | name |
+-------+--------+
| 00001 | 张三 |
+-------+--------+
1 row in set (0.00 sec)