请参考 http://www.3lian.com/edu/2013/07-15/80916.html

 

分表查询
   select * from (
   select * from user0   union  
   select * from user1  union
   select * from user2  union
   select * from user3
) as  t order by t.id

posted on 2016-01-12 15:52  allen817  阅读(138)  评论(0编辑  收藏  举报