mysql - "Categorize"或 "Mark"选择查询

Question

我有一个查询，该查询从多个数据库中进行选择，其中列“auth”= mad:

$result = mysql_query("SELECT * FROM test.1 WHERE auth = 'mad' LIMIT 1 
    UNION SELECT * FROM test.2 WHERE auth = 'mad' LIMIT 1 
    UNION SELECT * FROM test.3 WHERE auth = 'mad' LIMIT 1");

如何对从 test.1 获得的结果进行标记或分类；测试.2 还是测试.3 ？

非常感谢。

Answer 1

将表名称添加到结果中:

$result = mysql_query("SELECT *, 'test.1' FROM test.1 WHERE auth = 'mad' LIMIT 1 
                  UNION SELECT *, 'test.2' FROM test.2 WHERE auth = 'mad' LIMIT 1 
                  UNION SELECT *, 'test.3' FROM test.3 WHERE auth = 'mad' LIMIT 1");