mysql合并多个查询结果

1、mysql合并多个查询结果

SELECT 'zong',count(*) FROM  w_user_arrange 
UNION ALL
SELECT 'db0',count(*) FROM w_user_arrange_0
UNION ALL
SELECT 'db1',count(*) FROM w_user_arrange_1
UNION ALL
SELECT 'db2',count(*) FROM w_user_arrange_2
UNION ALL
SELECT 'db3',count(*) FROM w_user_arrange_3

2、验证结果

select sum(t1) from (
SELECT count(*) as t1 FROM w_user_arrange_0
UNION ALL
SELECT count(*) as t2 FROM w_user_arrange_1
UNION ALL
SELECT count(*) as t3 FROM w_user_arrange_2
UNION ALL
SELECT count(*) as t4 FROM w_user_arrange_3) as total