mysql中查询两个表同一条件的数据条数该怎么写sql语句
发布网友
发布时间：2022-05-02 06:19
共2个回答
懂视网
时间：2022-05-02 10:40
select
(select count(*) from device0 where status != 0),
(select count(*) from device1 where status != 0),
(select count(*) from device2 where status != 0),
(select count(*) from device3 where status != 0),
(select count(*) from device4 where status != 0),
(select count(*) from device5 where status != 0),
(select count(*) from device6 where status != 0),
(select count(*) from device7 where status != 0),
(select count(*) from device8 where status != 0),
(select count(*) from device9 where status != 0)
as count
select
(select count(*) from device0 where status != 0)+
(select count(*) from device1 where status != 0)+
(select count(*) from device2 where status != 0)+
(select count(*) from device3 where status != 0)+
(select count(*) from device4 where status != 0)+
(select count(*) from device5 where status != 0)+
(select count(*) from device6 where status != 0)+
(select count(*) from device7 where status != 0)+
(select count(*) from device8 where status != 0)+
(select count(*) from device9 where status != 0)
as count
mysql一条sql查询多个表数据量
标签：dev sql rom 表数据 查询 数据 from where device
热心网友
时间：2022-05-02 07:48
from
(
select id
from a
where id>5
union all
select id
from b
where id>5
)
