Mysql 将多张表联合成一张大表

Question

我有一个查询选择多个表的名称:

SELECT TABLE_NAME AS TABLES FROM INFORMATION_SCHEMA.TABLES

+---------------+
| TABLES        |
+---------------+
| A             |
| B             |
| <more tables> |
+---------------+

我想创建一个查询，其中每个表中的每个值都这样联合在一起:

+------------+----+----------+
| table_name | id | name     |
+------------+----+----------+
| A          | 1  | item1    | <- Items from Table A
| A          | 2  | item2    | 
| A          | 3  | item3    |
| B          | 1  | item1    | <- Items from Table B
| B          | 2  | item2    |
| <entries for other tables> |
+------------+----+----------+

有什么想法吗？提前致谢!

Answer 1

假设您在最宽松的意义上使用“聚合”...

select 'A' as table_name, id, name
from table_a
union all
select 'B' as table_name, id, name
from table_b