$sql="update tableName set wages+=100 where name like '张%'";
update table_name set salary = salary + 200 where age >=40 and salary < 20005793
参考UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
