my $sth = $dbh->prepare(
  "insert into table1 (col1, col2, col2) values (?, ?, ?)");