Update multiple columns in SQL

The “tiresome way” is standard SQL and how mainstream RDBMS do it.

With a 100+ columns, you mostly likely have a design problem… also, there are mitigating methods in client tools (eg generation UPDATE statements) or by using ORMs

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)