本文共 629 字,大约阅读时间需要 2 分钟。
其实这么写理论上是对的,很多博客教程都是这样子写的。。
select * from (SELECT * FROM article WHERE is_top=0 ORDER BY id DESC) as t1
select * from (SELECT * FROM article WHERE is_top=1 ORDER BY start_time desc) as t2
然后还是发现子查询的排序无效,尴尬,后来才发现如果order by 不带limit,会被优化器干掉,导致语句就是:
select * from (SELECT * FROM article WHERE is_top=0 ) as t1
select * from (SELECT * FROM article WHERE is_top=1) as t2
select * from (SELECT * FROM article WHERE is_top=0 ORDER BY id DESC limit 999999) as t1
select * from (SELECT * FROM article WHERE is_top=1 ORDER BY start_time desc limit 999999) as t2
http://blog.csdn.net/emaste_r/article/details/73550783