mysql - 获得总数的工会问题

Question

MySql中如何通过查询统计2条select语句的UNION总记录数？

(select name, phone from table1) UNION (select name, phone from table2)

Answer 1

您可以使用派生表:

SELECT COUNT(*)
FROM (
  (select name, phone from table1) 
  UNION 
  (select name, phone from table2)
  ) AS combined_table

UPD:这是一个fiddle