16 Dez 2016 09:36
SELECT SUM(QTDAGE) AS TOTALAGE, SUM(QTDINS) AS TOTALINS, SUM(QTDLOC) AS TOTALLOC FROM
(
select COUNT(*) AS QTDAGE, 0 AS QTDINS, 0 AS QTDLOC FROM JPANPAGE
UNION ALL
select 0 AS QTDAGE, count(*) AS QTDINS, 0 AS QTDLOC from JPANPINS
UNION ALL
select 0 AS QTDAGE, 0 AS QTDINS, count(*) AS QTDLOC FROM JPANPLOC
) AS SOMA
16 Dez 2016 09:51
SELECT table_name, TABLE_ROWS
FROM information_schema.TABLES
where table_name in ('tb1', 'tb2', 'tb3') AND table_schema="nome_do_schema"
group by table_name;
16 Dez 2016 12:17
16 Dez 2016 12:21
16 Dez 2016 20:13
21 Dez 2016 13:04
21 Dez 2016 13:16
select
(
( select count(*) From log_cpc ) +
( select count(*) from log_localidade ) +
( select count(*) from log_logradouro ) +
( select count(*) from log_unid_oper ) +
( select count(*) from log_grande_usuario )
)
as QTD
21 Dez 2016 17:47
21 Dez 2016 18:54
wmanesco escreveu:Estranho mesmo...
SELECT 1 + 2 + 3 AS QTD
21 Dez 2016 20:05
22 Dez 2016 10:51
alxsts escreveu: Não me causou estranheza mas é uma forma curiosa. Na verdade, a função agregada Count() retorna um numérico. A consulta apresentada apenas soma os resultados numéricos retornados.