php – 将LIMIT 1添加到COUNT个查询

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了php – 将LIMIT 1添加到COUNT个查询，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1414字，纯文字阅读大概需要3分钟。

内容图文

这是我用来显示页面的COUNT查询：

$sql = "
SELECT SUM(num) as num FROM (
  SELECT
    COUNT(URL) AS num
    , 'World' AS GoSection
    , 'GW' AS MySite
  FROM gw_geog
  WHERE URL = :MyURL AND G1 = 1
UNION ALL
  SELECT
    COUNT(URL) AS num
    , 'World' AS GoSection
    , 'GW' AS MySite
  FROM gw_geog_political
  WHERE URL = :MyURL
 ) AS X";

$stmt = $pdo->prepare($sql);
$stmt->bindParam(':MyURL',$MyURL,PDO::PARAM_STR);
$stmt->execute();
$Total = $stmt->fetch();

我想做两个改变：

1)从每行删除WHERE URL =：MyURL,并将其合并到查询末尾的单行中

2)通过添加LIMIT 1来重复Zap

这就是我现在正在使用的.

$sql = "SELECT SUM(num) as num FROM (
 SELECT COUNT(URL) AS num, 'World' AS GoSection, 'GW' AS MySite FROM gw_geog WHERE URL = :MyURL AND G1 = 1
 UNION ALL
 SELECT COUNT(URL) AS num, 'World' AS GoSection, 'GW' AS MySite FROM gw_geog_political WHERE URL = :MyURL
 ) AS X
WHERE X.URL LIKE :MyURL LIMIT 1";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':MyURL',$MyURL,PDO::PARAM_STR);
$stmt->execute();
$Total = $stmt->fetch();

但是,我收到错误消息Unknown column X.SUM(或X.URL等).

有人能告诉我这样做的正确方法吗？

解决方法:

使用Query As Follows,您将获得所需的输出：

 SELECT
    SUM(num) AS num
FROM
(
    SELECT
        COUNT(URL) AS num,
        'World' AS GoSection,
        'GW' AS MySite,
        gw_geog.`URL` as URL  
    FROM
        gw_geog
    WHERE
        URL = :MyURL
    AND G1 = 1
    UNION ALL
        SELECT
            COUNT(URL) AS num,
            'World' AS GoSection,
            'GW' AS MySite,
             gw_geog_political.`URL` as URL
        FROM
            gw_geog_political
        WHERE
            URL = :MyURL
) AS X
WHERE
    X.URL like  :MyURL
LIMIT 1

内容总结

以上是互联网集市为您收集整理的php – 将LIMIT 1添加到COUNT个查询全部内容，希望文章能够帮你解决php – 将LIMIT 1添加到COUNT个查询所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端