mysql中update修改某字段的值,使其自增

直接看示例

update test set age=age+5, year=year+age where Id = 1