update table1 t1 set filde = (select filde from table2 t2 where t1.xx = t2.xx)
日期拆分
select year(checkDate),month(checkDate) from table;
update table1 t1 set filde = (select filde from table2 t2 where t1.xx = t2.xx)
日期拆分
select year(checkDate),month(checkDate) from table;