drop table if exists test1; create table test1 ( id char(4), int_item int, varchar_item varchar(8), primary key (id) );