DB多表查询，多个表结构一样，怎么一次查回

Question

10张表，表结构一模一样，编号为IN01到IN10,怎么在db里面通过查询语句一次查回的满足表中字段AGE大于10的所有记录

Answer 1

两个方法

1. 用 union all 联合 10张表

   SELECT * FROM (
   SELECT * FROM IN01
   UNION ALL
   SELECT * FROM IN02
   UNION ALL
   SELECT * FROM IN03
   UNION ALL
   SELECT * FROM IN04
   UNION ALL
   SELECT * FROM IN05
   UNION ALL
   SELECT * FROM IN06
   UNION ALL
   SELECT * FROM IN07
   UNION ALL
   SELECT * FROM IN08
   UNION ALL
   SELECT * FROM IN09
   UNION ALL
   SELECT * FROM IN10
   ) AS IN_ALL WHERE AGE > 10
   

2. 用 mrg_myisam 表来聚合表