in reply to SQL UPDATE and DBI for MySQL

the correct syntax for UPDATE is something like: 
UPDATE  tbl_name
    SET col_name1=expr1, col_name2=expr2, ...
    WHERE where_definition

[download]

In Section Seekers of Perl Wisdom