update multiple columns

Sometimes database developers need to update multiple columns in MySQL. Here are different ways to update several columns in SQL.