Help for this page

Select Code to Download

Select or download this

insert into  foo    (bar, baz) 
             values (?,   ?)
on duplicate key update
             bar = values(bar)
           , baz = values(baz)

Select or download this

my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') 
            VALUES (' . join(',', ('?') x keys %sql) . ') 
            ON DUPLICATE KEY UPDATE '. join(', ', map { "$_ = values($
+_)" } keys %sql);