27,579
社区成员
发帖
与我相关
我的任务
分享
select alid from TypeList where pinyin like '%hanguan%'
SELECT * FROM productlist where alid in (1,3,6,20)
with yyyyyy
as
(select alid from TypeList where pinyin like '%hanguan%'
)
SELECT *
FROM productlist
where alid in (yyyyyy)
select * from productlist as pl INNER JOIN TypeList as tl on tl.alid=pl.alid
where t1.pinyin like '%hanguan%'
select * from productlist where pinming like '%hanguan%'
速度太慢了。
但是, 类型表typelist 行数较少,可以用:like 模糊查询 出:alid;
select alid from typelist where pinyin like '%hanguan%'
alid 完全是 数值型int 的,并且,在产品表productlist中,每条产品信息,都有对应的 alid。所以,就用
select * from productlist. where alid in (yyyyy)
期望提升 查询速度。我的思路正确吗?SELECT *
FROM productlist
WHERE alid IN ( SELECT alid
FROM TypeList
WHERE pinyin LIKE '%hanguan%' );
with yyyyyy
as
(select alid from TypeList where pinyin like '%hanguan%'
)
SELECT * FROM productlist T2
where EXISTS(SELECT 1 FROM yyyyyy T1 WHERE T1.alid =T2.alid )