Help for this page

Select Code to Download


  1. or download this
    my $sthC = $dbh->prepare("insert TABLE (col1, col2, ...)
    values(?, ?, ?)")
        or die "Couldn't prepare: $DBI::errstr";
    $sthC->execute('value1', 'value2', ...)
        or die "Couldn't execute: $DBI::errstr";
    
  2. or download this
    my @values = qw(...);
    my $sql = q{
    insert
    ...
       or die "Couldn't prepare $sql: $DBI::errstr";
    $sth->execute(@values)
        or die "Couldn't execute $sql: $DBI::errstr";