Help for this page

Select Code to Download


  1. or download this
    
    my @records = ( ['value1', 'value2'], ...) ;
    ...
    my $sth    = $dbh->prepare($query);
    $sth->execute(map { @$_ } @records);
    
  2. or download this
    my @list; 
    foreach (@records) { 
         push(@list,"( ?, ?, ? )");
    } 
    my $values = join(',', @list);
    
  3. or download this
    
    join ", ", ("( ?, ? )" x @records);