我们现在像要将time_attendance.cux_t_ks_bi的数据全部同步到time_attendance.cux_t_ks_bi_merge表中,这两张表的字段都是一样的,
replace into time_attendance.cux_t_ks_bi_merge(eventdtm,comp,deptid,position2,personnum,fullnm,`position`,startpunch,endpunch,
cq,sbck,xbck,jb,cc,sj,yxj,prj,kg,cdzt,cdzt_m,xx,cqgs,jsgs,shiftstartdate,shiftenddate,gwlx) SELECT eventdtm,comp,deptid,position2,personnum,fullnm,`position`,startpunch,endpunch,
cq,sbck,xbck,jb,cc,sj,yxj,prj,kg,cdzt,cdzt_m,xx,cqgs,jsgs,shiftstartdate,shiftenddate,gwlx from time_attendance.cux_t_ks_bi;