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 |
|