摘要： merge into sm_classes sc using (select * from ceibs_uv_embaclass) c on(sc.id = c.id) when matched then update set sc.classname=c.classname,sc.groupname=c.group_namewhen not matched then insert (sc.id,sc.classname,sc.groupname)values (c.id,c.classname,c.group_name) 阅读全文