首页 > 其他 > 详细

2016/1/18 问题记载

时间:2016-01-18 20:39:07      阅读:214      评论:0      收藏:0      [点我收藏+]

1:SELECT t.ID,t.CHANNEL_ID,t.`NAME`,t.LOGO,t.START_TIME,t.END_TIME,t.PROGRAM_DATE,
(SELECT GROUP_CONCAT(DISTINCT tca.NICK_NAME) FROM TBL_ANCHORPERSON_RESOURCE tar,TBL_CLOUDTB_ADMIN tca
WHERE t.ID=tar.RESOURCE_ID AND tar.TYPE=1 AND tar.ANCHORPERSON_ID = tca.ID GROUP BY tar.RESOURCE_ID ) ANCHORPERSON
FROM TBL_PROGRAM t
WHERE t.CHANNEL_ID =34
ORDER BY START_TIME ASC

2:SELECT t.ID,t.CHANNEL_ID,t.`NAME`,t.LOGO,t.START_TIME,t.END_TIME,t.PROGRAM_DATE,temp.ANCHORPERSON

FROM TBL_PROGRAM t,
(SELECT tp.id,GROUP_CONCAT(DISTINCT tca.NICK_NAME) ANCHORPERSON
FROM TBL_ANCHORPERSON_RESOURCE tar,TBL_CLOUDTB_ADMIN tca,tbl_program tp
WHERE tar.RESOURCE_ID=tp.ID AND tar.TYPE=1 AND tar.ANCHORPERSON_ID = tca.ID GROUP BY tar.RESOURCE_ID) temp
WHERE t.CHANNEL_ID = 34
AND temp.id=t.ID
GROUP BY `NAME`
ORDER BY START_TIME ASC

 

2的查询速度远远比1的快:

 

2016/1/18 问题记载

原文:http://www.cnblogs.com/ben9402/p/5140234.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!