mysql联表多表查询,以前查询的时候,可以直接select * from tablea as a ,tableb.as b where a.cc=b.cc.今天分享一个新奇的写法,而且对于百W数据执行效率可是相当的快,下面分享一下联表多表查询的几个语句:
SQL代码
- #在Tbl_User中删除非法积分数据的QQ的邀请好友QQ资料
- delete from Tbl_User where FQQ IN
- (select FDesQQ from Tbl_InviteHistory where FSrcQQ IN
- (select DISTINCT(FSrcQQ) from Tbl_ScoreDetail where FScore>'250' and FStrategy='4'))
- #在Tbl_User中删除非法积分数据的QQ资料
- delete from Tbl_User where FQQ IN
- (select DISTINCT(FSrcQQ) from Tbl_ScoreDetail where FScore>'250' and FStrategy='4')
- #在Tbl_InviteHistory中删除所有非法积分数据的邀请记录
- delete from Tbl_InviteHistory where FSrcQQ IN
- (select DISTINCT(FSrcQQ) from Tbl_ScoreDetail where FScore>'250' and FStrategy='4')
- #在Tbl_Score中删除非法积分数据的总积分
- delete from Tbl_Score where FQQ IN
- (select DISTINCT(FSrcQQ) from Tbl_ScoreDetail where FScore>'250' and FStrategy='4')
- #在Tbl_ScoreDetail中删除非法积分明细
- delete from Tbl_ScoreDetail where FScore>'250' and FStrategy='4'
- #删除Tbl_Score表里没有Tbl_User的用户
- delete from Tbl_Score where FQQ not IN (select FQQ from Tbl_User)
- delete from Tbl_ScoreDetail where FSrcQQ not IN (select FQQ from Tbl_User)
- //查兑换码大于20的用户明细表
SELECT FQQ,FCode,FApplyTime FROM Tbl_Code where FQQ in (SELECT a.FQQ FROM (SELECT COUNT(*) as num,FQQ FROM `Tbl_Code` GROUP BY FQQ HAVING num>20) as a) and FStatus='1'