sql简写或优化

ziyuanxian ziyuanxian 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
select 
(select path from chuangye_deepcate WHERE id=102)as path ,
(select catename from chuangye_deepcate WHERE id=102)as lanmutitle ,
(select lanmumuban from chuangye_deepcate WHERE id=102)as lanmumuban ,
(select keyword from chuangye_deepcate WHERE id=102)as keyword ,
(select zaiyao from chuangye_deepcate WHERE id=102)as zaiyao ,
(select jiaodiantu from chuangye_deepcate WHERE id=102)as jiaodiantu ,
(select iflink from chuangye_deepcate WHERE id=102)as iflink ,
(select linkurl from chuangye_deepcate WHERE id=102)as linkurl ,
(select ifdanye from chuangye_deepcate WHERE id=102)as ifdanye ,
(select content from chuangye_deepcate WHERE id=102)as content ,
(select pagesize from chuangye_deepcate WHERE id=102)as pagesize ,
n.id, n.title,n.smpic,n.addtime,n.zaiyao as conzaiyao from chuangye_news n where n.classid in(102,93,103,127,126) order by paixu desc,id desc

拼接多个(select xx from yy)as cc,这个可以一次多个吗,或者有什么更优秀的写法吗,感觉太长,感觉效率不是很高
...全文
评论 3
收藏 已收藏
分享
返回顶部
ziyuanxian
MySQL 57,062 成员 56,759 内容