http://www.perlmonks.org?node_id=1083557


in reply to Re: Replacing DBI->do()
in thread Replacing DBI->do()

"INSERT INTO ... SET foo=bar"

See INSERT:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name
    SET col_name={expr | DEFAULT}, ...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

[download]

Surprise! I didn't know it too.

Best regards, Karl

«The Crux of the Biscuit is the Apostrophe»

In Section Seekers of Perl Wisdom