mysql> create table test (a int, b char(1)); Query OK, 0 rows affected (0.05 sec) mysql> insert into test values (1, 'A'); Query OK, 1 row affected (0.06 sec) mysql> insert into test (a, b) values (2, 'B'); Query OK, 1 row affected (0.06 sec) mysql> select * from test; +------+------+ | a | b | +------+------+ | 1 | A | | 2 | B | +------+------+ 2 rows in set (0.05 sec)