mysql用同一张表中的一个字段更新另外一个字段

select count(*) from HEALTH_HYPER_PATI_SERVICE_NEW

select count(*) from HEALTH_HYPER_PATI_SERVICE_NEW where COLLECT_MODE is null
update HEALTH_HYPER_PATI_SERVICE_NEW a set a.COLLECT_MODE=a.VISIT_MODE,a.VISIT_MODE=2 where COLLECT_MODE is null;