MERGEINTO table2 t2USING table1 t1ON t2.email = t1.emailWHEN MATCHED THENUPDATESET t2.col1 = t1.col1, t2.col2 = t1.col2WHEN NOT MATCHED THENINSERT (col1, col2)VALUES (t1.col1, t1.col2)
MERGEINTO table2 t2USING table1 t1ON t2.email = t1.emailWHEN MATCHED THENUPDATESET t2.col1 = t1.col1, t2.col2 = t1.col2WHEN NOT MATCHED THENINSERT (col1, col2)VALUES (t1.col1, t1.col2)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
