本文介绍了使用SQL进行表差异对比的方法，通过示例展示了如何找出两个表之间的不同之处，并提供了删除多余数据的技巧。此外，还讲解了如何将一个表中的特定字段选择性地插入到另一个表中。
1、sql比较表差异
select count(*) from
(select id from aclid minus select aclid from rule)
delete from aclid where id in
(select id from aclid minus select aclid from rule)
2、选择表1字段插入表2
insert into table2(param1,param2)
select distinct param1,0 from table1
select count(*) from
(select id from aclid minus select aclid from rule)
delete from aclid where id in
(select id from aclid minus select aclid from rule)
2、选择表1字段插入表2
insert into table2(param1,param2)
select distinct param1,0 from table1
扫一扫
2565
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
