bradcathey has asked for the wisdom of the Perl Monks concerning the following question:
Fellow Monasterians,
I'm new to the INSERT ... ON DUPLICATE KEY UPDATE concept and now have been staring at this for an hour and not seeing the problem. Here's the code:
my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') VA +LUES (' . join(',', ('?') x keys %sql) . ') ON DUPLICATE KEY UPDATE ' +. join(' = ?, ', keys %sql) . ' = ?';
Data::Dumper gives me:
$VAR1 = 'INSERT INTO contact_form (more_info,city,name,address,comment +s) VALUES (?,?,?,?,?) ON DUPLICATE KEY UPDATE more_info = ?, city = ? +, name = ?, address = ?, comments = ?';
Run-time error message
...for the right syntax to use near ' city = , name = , address = , co +mments ='
What am I missing? (BTW, it works fine if I leave off the
)ON DUPLICATE KEY UPDATE ' +. join(' = ?, ', keys %sql) . ' = ?'
—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: MySQL syntax error for ON DUPLICATE KEY UPDATE
by dvergin (Monsignor) on Jul 20, 2008 at 01:48 UTC | |
by bradcathey (Prior) on Jul 20, 2008 at 03:00 UTC | |
by rhesa (Vicar) on Jul 20, 2008 at 08:12 UTC | |
Re: MySQL syntax error for ON DUPLICATE KEY UPDATE
by pc88mxer (Vicar) on Jul 20, 2008 at 00:08 UTC |
Back to
Seekers of Perl Wisdom