MySQL 5.0.x表goods1和表goods2,两表结构和数据不完全一样,相同的字段goods_id。以两个表中都有的字段goods_id为基准1。删除goods2表中比goods1表中多的记录
2。查询出goods2表比goods1中缺少的记录请高手指点,解决立即结贴,谢谢!
2。查询出goods2表比goods1中缺少的记录请高手指点,解决立即结贴,谢谢!
解决方案 »
- 急、急 mysql5.1.50能定时执行这个存储过程吗
- 如何在SQLyog的表中加入记录
- 新入手MYSQL,虚心请教
- mysql存储过程中怎么动态构造含表名的生气了sql语句
- sql语句:如何查询某列中所有的值但避免数据重复
- 求mysql的一个sql语句!
- 用mysqldump导出的整库备份, 用什么方法才能够导入呢(整库恢复)
- 怎么用程序将excel的数据导汝mysql的数据库?
- SQLServer和MySQL的同步问题
- 两张表联合查询,然后又要标示是哪张表查询出来的,需要根据这个类型去具体哪张表查出详细信息
- mysql 与 source...
- 手动注册mysql免安装版服务 跪求高手!!!
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);