$query = qq| INSERT INTO foo VALUES ( '$bar', '$baz' )|; $sth = $dbh->prepare($query); $sth->execute(); #### $query = qq| INSERT INTO foo VALUES ( ?, ? ) |; $sth = $dbh->prepare($query); $sth->execute($bar,$baz);