1 delete a from goods2 a LEFT JOIN goods1 B ON A.goods_id=B.goods_id WHERE B.goods_id IS NULL 2 SELECT A.* FROM goods2 a RIGHT JOIN goods1 B ON A.goods_id=B.goods_id WHERE A.goods_id IS NULL
1:delete goods2,goods1 from goods2 left join goods1 on goods2.goods_id =goods1.goods_id where goods1.goods_id is null; 2:select goods1.* from goods1 a left join goods2 b on a.goods_id=b.goods_id where b.goods_id is null;
2 SELECT b.* FROM goods2 a RIGHT JOIN goods1 B ON A.goods_id=B.goods_id WHERE A.goods_id IS NULL
1。删除goods2表中比goods1表中多的记录 delete from goods1 where goods_id not in (select goods_id from goods2); 2。查询出goods2表比goods1中缺少的记录 delete from goods2 where goods_id not in (select goods_id from goods1);
delete a from goods2 a LEFT JOIN goods1 B ON A.goods_id=B.goods_id WHERE B.goods_id IS NULL
2
SELECT A.* FROM goods2 a RIGHT JOIN goods1 B ON A.goods_id=B.goods_id WHERE A.goods_id IS NULL
2:select goods1.* from goods1 a left join goods2 b on a.goods_id=b.goods_id where b.goods_id is null;
SELECT b.* FROM goods2 a RIGHT JOIN goods1 B ON A.goods_id=B.goods_id WHERE A.goods_id IS NULL
delete from goods1 where goods_id not in (select goods_id from goods2);
2。查询出goods2表比goods1中缺少的记录
delete from goods2 where goods_id not in (select goods_id from goods1);