$sth = $dbh->prepare("INSERT INTO snp_db (rs,chr_position,band,alleles,het,validated,gene,role,relative_pos,aa_change,flanking_seq) VALUES (?,?,?,?,?,?,?,?,?,?);"); $sth->execute($rs_number,$position,$band,$alleles,$het,$val,$gene,$role,$pos,$aa); #### $sth = $dbh->prepare("UPDATE snp_db SET (chr_position,band,alleles,het,validated,gene,role,relative_pos,aa_change,flanking_seq) VALUES (?,?,?,?,?,?,?,?,?) WHERE rs = $rs_number;"); $sth->execute($position,$band,$alleles,$het,$val,$gene,$role,$pos,$aa);