17,086
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO table_A_Backup(
SELECT * FROM table_A src
WHERE EXISTS (SELECT 0 FROM table_middle md WHERE 1=1 AND src.column_a = md.column_a)
)
);
DELETE FROM table_A
WHERE EXISTS (SELECT 0 FROM table_middle md WHERE 1=1 AND src.column_a = md.column_a);
select count(0) from table_A;
select count(0) from table_A_Backup;
SELECT count(*) FROM table_A src
WHERE EXISTS (SELECT 0 FROM table_middle md WHERE 1=1 AND src.column_a = md.column_a)
)
用几个count(*)确认记录数是否一致