Help for this page
my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') VA
+LUES (' . join(',', ('?') x keys %sql) . ') ON DUPLICATE KEY UPDATE '
+. join(' = ?, ', keys %sql) . ' = ?';
$VAR1 = 'INSERT INTO contact_form (more_info,city,name,address,comment
+s) VALUES (?,?,?,?,?) ON DUPLICATE KEY UPDATE more_info = ?, city = ?
+, name = ?, address = ?, comments = ?';
...for the right syntax to use near ' city = , name = , address = , co
ON DUPLICATE KEY UPDATE '
+. join(' = ?, ', keys %sql) . ' = ?'
By rote learning.
Via Genetic memory.
It's provided by my firmware.
I just remember them.
Thirty days hath September
My computer gets it right, usually.
I just ask someone else.
Someone punches me on the first of the month.
Results (391 votes),