Miscellany

mysql> create table test1 (col1 int(5) zerofill);ERROR 1050 (42S01): Table 'test1' already existsmysql> 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: 0mysql> select * from test1;+-----------+| col1      |+-----------+|     00001 | |     10001 | | 100000001 | +-----------+3 rows in set (0.01 sec)mysql> alter table test1 modify col1 int(5);Query OK, 3 rows affected (0.01 sec)Records: 3  Duplicates: 0  Warnings: 0mysql> select * from test1;+-----------+| col1      |+-----------+|         1 | |     10001 | | 100000001 | +-----------+3 rows in set (0.00 sec)