update table1,table2 set table1.filed1 = table2.filed1
where table1.id=table2.tb1Id
- 插入
INSERT INTO jf_p_bizunit (
BUID,
BU_NAME,
PHONE,
FAX,
EMAIL,
ADDRESS,
GROUPID,
BUTYPE
) SELECT
BUID,
BU_NAME,
PHONE,
FAX,
EMAIL,
ADDRESS,
GROUPID,
BUTYPE
FROM
jf_p_bizunit_copy