my $sth = $dbh -> prepare("insert into table1 (col1, col2, col2) values (?, ?, ?)"); #### my $sth = $dbh->prepare( "insert into table1 (col1, col2, col2) values (?, ?, ?)"); #### my $updater = $dbh -> prepare("update table1 set col1 = ?, col2 = ?, col3 = ? where col1 = ? and col2 = ? and col3 = ?"); #### my $updater = $dbh -> prepare( "update table1 set col1 = ?, col2 = ?, col3 = ? \ where col1 = ? and col2 = ? and col3 = ?"); #### my $updater = $dbh->prepare( "update table1 set col1 = ?, col2 = ?, col3 = ? where id = $ID");