Help for this page

Select Code to Download


  1. or download this
    my $sql   = "insert into foo values (?,?,?)";
    my @binds = qw/alpha beta gamma/;
    ...
        $sql  =~ s/\?/ $dbh->quote( $binds[$i++] ) /ge;
    }
    # "insert into foo values ('alpha','beta','gamma')"
    
  2. or download this
    my $sql   = "insert into foo values (?, ?)";
    my @binds = ("Huh?", "What?");
    
    # correct:  "insert into foo values ('Huh?', 'What?')"
    # mysqlPP:  "insert into foo values ('Huh'What?'', ?)"