- 新建一个表并备份旧表数据
create table table_new select * from table_old
- 获取两个表之间的差集
select * from table_1 where id not in (select id from table_2 )
create table table_new select * from table_old
select * from table_1 where id not in (select id from table_2 )
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
