use test; drop table if exists test.tbl; create table test.tbl ( id bigint unsigned not null auto_increment, product varchar(255) not null, unique index tbl_00 (id) ) type=innodb; insert into tbl (product) values ('a'); insert into tbl (product) values ('b'); insert into tbl (product) values ('c'); insert into tbl (product) values ('d');