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;
| Home | Archives | Categories | Tags | About |
|