MySQL 修改日期字段的值，在另一个字段的基础上减多少天

-- update {表名} set {字段1} = DATE_SUB({字段2}, INTERVAL {字段3} day)
UPDATE mmis_measuring_equipment c set c.plan_generation_date = DATE_SUB(c.latest_inspection_date, INTERVAL plan_generation_day day)