ythook的专栏

复制一个表的其中两个字段到另一个表中对应的相同字段话不多说，直接上代码update tbl_norm n set (n.ADDRESS_AREA, n.ADDRESS) = (select m.ADDRESS_AREA, m.ADDRESS from ( select ID, ADDRESS_AREA, ADDRESS from tbl_info group by ID, ADDRESS_AREA, ADDRESS ) m where m.ID= n.ID);...