then again you could do it the poormans way

$update = $dbh->prepare("UPDATE snp_db SET chr_position=?, band=?, all
+eles=?, etc=? WHERE rs=$whatever");

$update->execute($val, $val2, $val3, $etcval);
[download]

though the above solution of using replace is probably better.