my $sth = $dbh->prepare("INSERT INTO foo (col1,col2,col3) VALUES(?,?,?)"); $sth->execute($value1, $value2, $value3);