SELECT
sum( t.count ) as sum
FROM
( SELECT count(*) AS 'count' FROM eswa_warning_type
UNION ALL
SELECT count(*) AS 'count' FROM eswa_warning_template ) t
MySql计算多个表的数据总行数
最新推荐文章于 2024-05-04 23:20:08 发布
SELECT
sum( t.count ) as sum
FROM
( SELECT count(*) AS 'count' FROM eswa_warning_type
UNION ALL
SELECT count(*) AS 'count' FROM eswa_warning_template ) t