mysql查询各种类型的前N条记录,将3改为N(需查询条数)即可  
(select * from event_info where event_type = 1  limit 3)
union all
(select * from event_info where event_type = 2  limit 3)
union all
(select * from event_info where event_type = 3  limit 3)


 

 

原文出处:http://my.oschina.net/u/1032146/blog/149300

posted on 2015-08-21 18:02  何石-博客  阅读(1927)  评论(0编辑  收藏  举报