insert into pos_reader(posid,posid_type,cmdbid,changed,balance,cardnum,status_msg) values(18032,2,0,0,0,'','skip old'),(3943931,1,0,0,0,'','skip old'); select max(posid),posid_type from pos_reader group by posid_type;