mysql - 查询多个表相同的表具有不同的值Mysql

Question

我需要一些有关 mysql 的帮助，因为我是它的新手。我需要统计不同数据库中不同表的值并将它们全部放在一个表中，然后为每个计数建立一个索引，例如:

 _______________________
|           |           |
|  Indexes  |   Counts  |
|___________|___________|
|           |           |
|  Index 1  |  Count 1  |
|___________|___________|
|           |           |
|  Index 2  |  Count 2  |
|___________|___________|
|           |           |
|  Index 3  |  Count 3  |
|___________|___________|
|           |           |
|  Index 4  |  Count 4  |
|___________|___________|

但是就像我现在正在做的那样(使用 UNION)，它看起来像:

 ___________
|           |
|  Counts   |
|___________|
|           |
|  Count 1  |
|___________|
|           |
|  Count 2  |
|___________|
|           |
|  Count 3  |
|___________|
|           |
|  Count 4  |
|___________|

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

编辑:

我当前使用的代码是这个

SELECT COUNT(*) AS "db1" FROM `db1`.`tb1`
UNION
SELECT COUNT(*) AS "db2" FROM `db2`.`tb2`

Answer 1

试试这个。

SELECT "db1.tb1" as "INDEXES", COUNT(*) AS "COUNTS" FROM `db1`.`tb1`
UNION
SELECT "db2.tb2" as "INDEXES", COUNT(*) AS "COUNTS" FROM `db2`.`tb2`