Help for this page

Select Code to Download


  1. or download this
    ...
    my $col_spec = my $val_spec = "(";
    ...
    $val_spec =~ s/,$/\)/;
    
    my $sql = "insert into my_table $col_spec values $val_spec";
    
  2. or download this
    my $col_spec = join( ",", sort keys %data );
    my $val_spec = join( ",", map { $data{$_} } sort keys %data );
    my $sql = "insert into my_table ($col_spec) values ($val_spec)";