mysql> create table test1 (col1 int(5) zerofill); ERROR 1050 (42S01): Table 'test1' already exists mysql> drop table test1; Query OK, 0 rows affected (0.00 sec) mysql> create table test1 (col1 int(5) zerofill); Query OK, 0 rows affected (0.00 sec) mysql> insert into test1 values (1),(10001),(100000001); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from test1; +-----------+ | col1 | +-----------+ | 00001 | | 10001 | | 100000001 | +-----------+ 3 rows in set (0.01 sec)