-- 往a表插入a表在b表中的不存在数据(id判断)
INSERT into table_A (
B_id,
col_a,
col_b,
col_c,
status)
SELECT
id, col_a, col_b, col_c from table_B as b
where NOT EXISTS(
SELECT 'X' FROM table_A as a where a.B_id = b.id
);
-- 往a表插入a表在b表中的不存在数据(id判断)
INSERT into table_A (
B_id,
col_a,
col_b,
col_c,
status)
SELECT
id, col_a, col_b, col_c from table_B as b
where NOT EXISTS(
SELECT 'X' FROM table_A as a where a.B_id = b.id
);