Question

I got a database named accounts and account table inside of this database, Also I got the database named players and player table inside of this database.

How can I get a rows count of this two tables in one query?

我试图这样做:

SELECT
    SUM(`account`.`account`.`id`) AS  accounts ,
    SUM(`player`.`player`) AS  players ;

但它没有工作。

Answer 1

如果你确实需要浏览量(而不是总合),那么情况就好像:

select
(select count(*) from accounts.account) as count1,
(select count(*) from players.player) as count2

或

select count(*) as `count`,"account" as `table` from accounts.account
union all
select count(*) as `count`,"player" as `table` from players.player

Answer 2

A simple UNION operation on two select statements will do:

SELECT COUNT(*),  Accounts  FROM Accounts.Account
UNION
SELECT COUNT(*),  Players  FROM Players.Player

并且,由于每个表格都重新列入单独的数据库,因此,你必须用数据库名称对每个表格进行认证。

Answer 3

Try:

SELECT
   COUNT(`account`.`id`) AS  accounts ,
   COUNT(`player`.`player`) AS  players 
FROM
   `account`,
   `player`

Answer 4

SELECT COUNT(*) 
FROM (
    SELECT Id 
    FROM accounts.account 
    UNION ALL 
    SELECT player 
    FROM players.player ) AS BothTables

Answer 5

with Value (nbr, name ) as
(
select count(*) amount,  AccountsCount  as ab from accounts..account
union all
select count(*) amount,  PlayersCount  as ab from players..player
)
select * 
from value as s
PIVOT(sum(nbr) for name in (AccountsCount, PlayersCount) ) as pvt

友情链接