douke3007 2014-12-10 14:35
浏览 125
已采纳

在一个查询中显示多个表的计数

I have a question, I want to get counts of different tables in one query to show on a page...

This the query i wrote, But it's not providing correct result..

SELECT COUNT(U.uID) AS total, COUNT(P.cID) AS Catmame FROM `dev_web_user` AS U, `dev_web_categories` AS P

Please note all count is independent, now join etc...

Please help me on this...

Thanks & Best Regards,

  • 写回答

2条回答 默认 最新

  • doulei3488 2014-12-10 14:52
    关注

    You can do this by joining them as two different temporary tables.

    Try this way:

    SELECT  * FROM
    (SELECT COUNT(*) AS total FROM `dev_web_user`) T1 JOIN
    (SELECT COUNT(*) AS Catmame FROM `dev_web_categories`) T2 ON 1=1
    

    Sample Output:

    TOTAL   CATMAME
    4       8
    

    See working demo in SQL Fiddle.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗