SQL语句积累
1. 查询多张表数据总数
select sum(num) from
(select count(*) as num from phone
union all
select count(*) as num from phone1
……
……
) a
1. 查询多张表数据总数
select sum(num) from
(select count(*) as num from phone
union all
select count(*) as num from phone1
……
……
) a