DROP TABLE IF EXISTS `test`.`test_table`; CREATE TABLE `test`.`test_table` ( `pk` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`pk`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; insert into test_table values (); insert into test_table values (); insert into test_table values (); select * from test_table;