Question

How can we update columns values on multiple rows with a single MySQL UPDATE statement?

Answer 1

In the UPDATE statement: First, specify the table name that you want to update data after the UPDATE keyword. Second, the SET clause specifies which column that you want to modify and the new values. To update multiple columns, you use a list of comma-separated assignments.