摘要： 批量插入 方式一 insert all into table(...) values(...) into table(...) values(...) select * from dual; <insert id="addList" parameterType="java.util.List" us 阅读全文

摘要： 不同表 MERGE INTO TABLE_A TA USING (SELECT * FROM TABLE_B TB) TB ON (TA.ID=TB.ID) WHEN MATCHED THEN UPDATE SET TA.NAME=TB.NAME WHEN NOT MATCHED THEN INSE 阅读全文