MySql updating many columns by A query

When we want to update many columns in one query,
we can just connect them with ,.
Let’s say we want to update A column to 1 and B column to 2 in one query.
Then we can do like this,

1
update table name set A = 1, B = 2;

Comments