# $comment is a text comment, $id is a integer

my $sql = "insert into my_table ".
          "(ID, COMMENT) " . 
          "values (?, ?)";

my $sth = $dbh->prepare($sql);
my $rc = $sth->execute($id, $comment);