MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1 (id int);
create table t2 (id int);
create table tarchive (id int);
insert into t1 values(1),(2),(3);
insert into t2 values(3),(4);
select * from t1;
select * from t2;
select * from tarchive;

id

1

2

3

id

3

4

insert into tarchive(id)
select t2.id 
from t2 
left join t1 on t2.id = t1.id
where t1.id is null;
delete from t2;
select * from t1;
select * from t2;
select * from tarchive;

id

1

2

3

id

4