i created a database like this, create table createpincode(id MEDIUMINT NOT NULL AUTO_INCREMENT,serialno char(30) Not NULL, pincode char(30)NOT NULL, type char(30)NOT NULL,primary key(1d));

...