select * from (select a,* from recordings a,(select recording_id from provisions where channel_name='cmcc') b where a.pid=b.recording_id ) as tb1
,(select distinct pid from recordings where kit like '%aa%') b
where a.pid=b.pid
这条语句还有
select * from (select a.* from recordings a inner join provisions b
on a.pid=b.recording_id
where b.cannel_name=’cmcc’)) as tb1
inner join recordings c on tb1.pid=c.pid
where c.kit like ‘%aa%’
都比优化前
select * from (select * from recordings where pid in (select recording_id from provisions where channel_name=’cmcc’)) as tb1 where pid in (select pid from recordings where kit like ‘%aa%’)
用时更长,这是什么原因呢
,(select distinct pid from recordings where kit like '%aa%') b
where a.pid=b.pid
这条语句还有
select * from (select a.* from recordings a inner join provisions b
on a.pid=b.recording_id
where b.cannel_name=’cmcc’)) as tb1
inner join recordings c on tb1.pid=c.pid
where c.kit like ‘%aa%’
都比优化前
select * from (select * from recordings where pid in (select recording_id from provisions where channel_name=’cmcc’)) as tb1 where pid in (select pid from recordings where kit like ‘%aa%’)
用时更长,这是什么原因呢
解决方案 »
- mysql 空表怎么取最大id?
- postgresql能否把一个数组转换成表结构?
- 请教一个强制用户退出的问题
- 求救SQL语句,高手进来
- mysql API BLOB数据的读写
- 请问postgresql-8.0.1只能安装在ntfs格式下吗?
- 数据库里的一个int字段test,我想实现全部+1
- 为什么我在2000下装MYSQL时老是报这个错,我错在那里啊,请大家指正,谢谢!!
- enum类型好么?
- 我没有启用二进制日志,如果误删可以通过ib_logfile文件恢复数据吗?
- MySQL安装配置过程中出现can't connect to mysql server on localhost 10061的错误
- MYSQL集群中冗余节点问题
,(select distinct pid from recordings where kit like '%aa%') b
where a.pid=b.pid 上面这条SQL找不到字段aselect * from (select a.* from recordings a inner join provisions b
on a.pid=b.recording_id
where b.cannel_name=’cmcc’)) as tb1
inner join recordings c on tb1.pid=c.pid
where c.kit like ‘%aa%’ 这条又括号不匹配。所以没什么可比的,永远跑不出记录集。建议楼主能贴个实际的例子,否则没办法帮你分析。提问反而变成考试大家的语法。