mysql> create table t1 (i int auto_increment primary key) engine = innodb auto_increment = 100; Query OK, 0 rows affected (0.10 sec) mysql> insert into t1 values (null), (null); Query OK, 2 rows affected (0.07 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from t1; +-----+ | i | +-----+ | 100 | | 101 | +-----+ 2 rows in set (0.00 sec)