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