Help for this page

Select Code to Download


  1. or download this
    
$sth = $dbh->prepare(
        sprintf "insert into %s (%s) values (%s) on duplicate key upda
+te $columns[0]=values($columns[0]),$columns[1]=values($columns[1])",
            $dbh->quote_identifier(
                $tablename
  2. or download this
    
printf "insert into %s (%s) values (%s) on duplicate key update %s=val
+ues(%s),%s=values(%s)",
...
            ),
            join( ',', ('?') x @columns ), ????