Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh->prepare("
   INSERT INTO Table (
...
          )
");
$sth->execute($foo, $bar);
  2. or download this
    my @fields = keys(%data);
my $q_fields = join ', ', map $dbh->quote_identifier($_), @fields;
...
          )
");
$sth->execute();
  3. or download this
    my @fields = keys(%data);
my $q_fields = join ', ', map $dbh->quote_identifier($_), @fields;
...
          )
");
$sth->execute(@data[ @fields ]);