+----+------+-------+
| id | name | value |
+----+------+-------+
| 1 | 5 | 00 |
| 2 | 8 | 00 |
| 3 | 6 | 00 |
+----+------+-------+UPDATE后结果+----+------+-------+
| id | name | value |
+----+------+-------+
| 1 | 5 | 10 |
| 2 | 8 | 13 |
| 3 | 6 | 11 |
+----+------+-------+计算方式:VALUE=5+name的值
update t1 set value=name+5;
SET a.value=COALESCE(a.name,0)+b.name;