MySQL - Update the same column twice
- by uzioriluzan
Hello,
I need to update a column in a mysql table.
If I do it in two steps as below, is the column "col" updated twice in the disk ?
update table SET col=3*col, col=col+2;
or is it written only once as in :
update table SET col=3*col+2;
Thanks