数据库跑了半天还没出结果怎么办?CPU满的。数据库 name 2M scorce 200M 都已经一个晚上了 还没结果。。。。是不是有问题?
...全文
14515打赏收藏
数据库跑了半天还没出结果怎么办?
我跑一个删除语句 delete from score where name not in ( select name1 from user union select name2 from user union select name3 from user); http://topic.csdn.net/u/20080608/10/fef03bac-d9ad-4fd4-a2c7-de26c20de966.html 数据库跑了半天还没出结果怎么办?CPU满的。数据库 name 2M scorce 2
delete score as a from score as a right join (
select name1 from user
union
select name2 from user
union
select name3 from user) as b where a.name is null;