sum

sum

关注
发信
关注(28)粉丝(399)

mysql - 如何在x个相同的MySQL SUM表上求和？

我有50个中心的50个数据库来记录执行的手术程序。我可以很容易地算出每个中心的这些程序的数量：

SELECT
ub.Krankenhaus AS "Zentrum",
"01" AS "ZentrumID",
SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
SUM(op.OP1OPVerfahren = "4") AS "Roux-en-Y Gastric Bypass banded",
SUM(op.OP1OPVerfahren = "5") AS "Scopinaro",
SUM(op.OP1OPVerfahren = "6") AS "Duodenal Switch (DS)",
SUM(op.OP1OPVerfahren = "7") AS "Sleeve Resection",
SUM(op.OP1OPVerfahren = "8") AS "Gastric Pacemaker",
SUM(op.OP1OPVerfahren = "9") AS "Billroth II",
SUM(op.OP1OPVerfahren = "10") AS "Gastroplasty",
SUM(op.OP1OPVerfahren = "11") AS "Fobi / Capella Bypass",
SUM(op.OP1OPVerfahren = "12") AS "Larrad",
SUM(op.OP1OPVerfahren = "13") AS "Santoro",
SUM(op.OP1OPVerfahren = "14") AS "DJB",
SUM(op.OP1OPVerfahren = "15") AS "TOGA",
SUM(op.OP1OPVerfahren = "16") AS "Endobarrier",
SUM(op.OP1OPVerfahren = "17") AS "Gastric Plication",
SUM(op.OP1OPVerfahren = "18") AS "Stomaphyx",
SUM(op.OP1OPVerfahren = "19") AS "Omega Loop Bypass",
SUM(op.OP1OPVerfahren = "20") AS "Omega Loop Bypass banded",
SUM(op.OP1OPVerfahren = "21") AS "Long Limb Bypass",
SUM(op.OP1OPVerfahren = "22") AS "Distal Very Long Gastric Bypass (Thurnheer)",
SUM(op.OP1OPVerfahren = "23") AS "Endoscopic Sclerosation",
SUM(op.OP1OPVerfahren = "24") AS "Swedish Adjustable Gastric Bypass (SAGB)",
SUM(op.OP1OPVerfahren = "25") AS "Vertical Banded Gastroplasty (VBG)",
SUM(op.OP1OPVerfahren = "26") AS "Plastic Abdominal Wall Reconstruction (PAWR)",
SUM(op.OP1OPVerfahren = "27") AS "Inner Hernia Repair",
SUM(op.OP1OPVerfahren = "28") AS "Single Anastomosis Duodeno-Ileal Bypass with Sleeve Gastrectomy (SADI-S)",
SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

FROM ods01.dat_patient p
LEFT OUTER JOIN ods01.dat_optherapie op ON op.patID = p.ID
LEFT OUTER JOIN ods01.users_benutzer ub ON ub.ID = p.UserID

WHERE 1 = 1
AND op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
AND p.Testzwecke = 0
AND ub.ID = p.UserID
AND NOT EXISTS (SELECT 1
    FROM ods01.dat_optherapie op2
    WHERE op2.PatID = p.ID AND op2.revision > op.revision
)


结果是一个不错的列表，我可以使用PHP进行布局，以便在左列中接收所有手术，在右列中接收相应的绝对数：

mysql - 如何在x个相同的MySQL SUM表上求和？-LMLPHP

使用

AND NOT EXIST blah


SQL查询末尾的语句我只允许最新的记录集修订。

使用

UNION ALL


我可以将所有50个中心的结果一个接一个地合并到这些表中。需要更长的滚动时间才能显示所有内容，但可以正常工作。

但：

我如何只创建一个结果表，将来自所有50个中心的所有手术的总和累加到该表中（总和为SUM）？

为了使事情更具体，这里是MCVE：

CREATE TABLE `dat_optherapie` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `patID` INT(10) NOT NULL,
    `OP1Datum` DATE NOT NULL,
    `OP1OPVerfahren` TINYINT(4) NOT NULL,
    `revision` INT(11) NOT NULL,
    PRIMARY KEY (`ID`),
    INDEX `ix_dat_optherapie_patid` (`patID`, `ID`, `OP1Datum`, `OP1OPVerfahren`, `revision`)
)
COLLATE='latin1_german1_ci'
ENGINE=MyISAM
AUTO_INCREMENT=7798;


以下是一些INSERT：

INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3307, 3005, '2017-06-22', 1, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3308, 3005, '2017-06-22', 1, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3960, 3005, '2017-06-22', 1, 4);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3977, 3005, '2017-06-22', 1, 5);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4246, 3005, '2017-06-22', 1, 6);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5571, 3005, '2017-06-22', 1, 7);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3578, 3067, '2017-09-21', 7, 1);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3579, 3067, '2017-09-21', 7, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3621, 3067, '2017-09-21', 7, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3661, 2905, '2017-03-15', 7, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3846, 2905, '2017-03-15', 7, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4165, 3067, '2017-09-21', 7, 4);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4378, 2905, '2017-03-15', 7, 4);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4704, 3251, '2018-03-27', 99, 1);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4705, 3251, '2018-03-27', 99, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4706, 3251, '2018-03-27', 99, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4707, 3251, '2018-03-27', 99, 4);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4708, 3251, '2018-03-27', 99, 5);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4735, 3251, '2018-03-27', 99, 6);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (4845, 2905, '2017-03-15', 7, 5);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5142, 3251, '2018-03-27', 99, 7);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5415, 3067, '2017-09-21', 7, 5);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5416, 3067, '2017-09-21', 7, 6);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5588, 3251, '2018-03-27', 99, 8);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5589, 3251, '2018-03-27', 99, 9);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5590, 3251, '2018-03-27', 99, 10);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5591, 3251, '2018-03-27', 99, 11);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (5891, 2905, '2017-03-15', 7, 6);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6007, 3362, '2018-09-18', 19, 0);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6008, 3362, '2018-09-18', 19, 1);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6045, 3362, '2018-09-18', 19, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6061, 3251, '2018-03-27', 99, 12);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6097, 3251, '2018-03-27', 99, 13);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6554, 3251, '2018-03-27', 99, 14);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (6555, 3251, '2018-03-27', 99, 15);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3042, 3010, '2017-07-10', 0, 1);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3043, 3010, '2017-07-10', 19, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3047, 3010, '2017-07-10', 19, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3048, 3010, '2017-07-10', 19, 4);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3049, 3010, '2017-07-10', 19, 5);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3066, 3010, '2017-07-10', 19, 6);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3067, 3010, '2017-07-10', 19, 7);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3073, 2968, '2017-05-08', 19, 2);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3074, 2968, '2017-05-08', 19, 3);
INSERT INTO `dat_optherapie` (`ID`, `patID`, `OP1Datum`, `OP1OPVerfahren`, `revision`) VALUES (3075, 2968, '2017-05-08', 19, 4);


表dat_patient仅用于整数字段Testzwecke，对于非测试患者，必须将其设置为0。表users_benutzer在这里可以完全省略（我将其保留在上面的原始代码中），它没有任何意义。表OP1OPVerfahren中的字段dat_optherapie只是相应手术过程的整数（也可以是字符串）值。

预期的结果是我已经在上传的屏幕快照中概述的结果。

下面是上面的SQL查询的简化示例：

SELECT
SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

FROM database1.dat_patient p
LEFT OUTER JOIN database1.dat_optherapie op ON op.patID = p.ID

WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
AND p.Testzwecke = 0
AND NOT EXISTS (SELECT 1
    FROM database1.dat_optherapie op2
    WHERE op2.patID = p.ID AND op2.revision > op.revision
)

UNION ALL

SELECT
SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

FROM database2.dat_patient p
LEFT OUTER JOIN database2.dat_optherapie op ON op.patID = p.ID

WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
AND p.Testzwecke = 0
AND NOT EXISTS (SELECT 1
    FROM database2.dat_optherapie op2
    WHERE op2.patID = p.ID AND op2.revision > op.revision
)

UNION ALL

[... many more identical SQL queries for other databases ...]

UNION ALL

SELECT
SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

FROM database50.dat_patient p
LEFT OUTER JOIN database50.dat_optherapie op ON op.patID = p.ID

WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
AND p.Testzwecke = 0
AND NOT EXISTS (SELECT 1
    FROM database50.dat_optherapie op2
    WHERE op2.patID = p.ID AND op2.revision > op.revision
)

GROUP BY OP1OPVerfahren;


此SQL代码在每个中心（而非所有中心）提供SUMmed记录集。后者是我想要实现的。

在实验上，我基于上面的改进代码对SQL查询进行了一些更改：

SELECT
SUM("Keine Operation durchgeführt"),
SUM("Bioenterics Intragastric Ballon (BIB)"),
SUM("Gastric Banding"),
SUM("Roux-en-Y Gastric Bypass"),
SUM("Anderes OP-Verfahren"),
SUM("Summe")

FROM (

    SELECT
    SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
    SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
    SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
    SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
    SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
    SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

    FROM ods01.dat_patient p
    LEFT OUTER JOIN ods01.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods01.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

    UNION ALL

    SELECT
    SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
    SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
    SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
    SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
    SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
    SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

    FROM ods02.dat_patient p
    LEFT OUTER JOIN ods02.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods02.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

    UNION ALL

    SELECT
    SUM(op.OP1OPVerfahren = "0") AS "Keine Operation durchgeführt",
    SUM(op.OP1OPVerfahren = "1") AS "Bioenterics Intragastric Ballon (BIB)",
    SUM(op.OP1OPVerfahren = "2") AS "Gastric Banding",
    SUM(op.OP1OPVerfahren = "3") AS "Roux-en-Y Gastric Bypass",
    SUM(op.OP1OPVerfahren = "99") AS "Anderes OP-Verfahren",
    SUM(op.OP1OPVerfahren LIKE "%") AS "Summe"

    FROM ods03.dat_patient p
    LEFT OUTER JOIN ods03.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN "2019-01-01" AND "2019-12-31"
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods03.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

    GROUP BY OP1OPVerfahren

) aftershave

-- GROUP BY OP1OPVerfahren;


如果我分别处理两个子查询UNIONed和每个子查询，它们将显示正确的结果。但是在主要SQL查询级别上的SUM，即i。 e。不在子查询中，则每个总和均显示为“ 0”。

最佳答案

好吧，在摆弄了“”，“和”字符后的解决方案是这样的：

SELECT
SUM(`Keine Operation durchgeführt`) AS `No surgery`,
SUM(`Bioenterics Intragastric Ballon (BIB)`) AS `BIB`,
SUM(`Gastric Banding`) AS `GB`,
SUM(`Roux-en-Y Gastric Bypass`) AS `RYGB`,
SUM(`Anderes OP-Verfahren`) AS `Other Surgery`,
SUM(`Summe`) AS `Total`

FROM
(

    SELECT
    COUNT(IF(op.OP1OPVerfahren = 0, 1, NULL)) AS `Keine Operation durchgeführt`,
    SUM(op.OP1OPVerfahren = 1) AS `Bioenterics Intragastric Ballon (BIB)`,
    SUM(op.OP1OPVerfahren = 2) AS `Gastric Banding`,
    SUM(op.OP1OPVerfahren = 3) AS `Roux-en-Y Gastric Bypass`,
    SUM(op.OP1OPVerfahren = 99) AS `Anderes OP-Verfahren`,
    SUM(op.OP1OPVerfahren LIKE '%') AS `Summe`

    FROM ods01.dat_patient p
    LEFT OUTER JOIN ods01.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN '1950-01-01' AND '2019-12-31'
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods01.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

    UNION ALL

    SELECT
    COUNT(IF(op.OP1OPVerfahren = 0, 1, NULL)) AS `Keine Operation durchgeführt`,
    SUM(op.OP1OPVerfahren = 1) AS `Bioenterics Intragastric Ballon (BIB)`,
    SUM(op.OP1OPVerfahren = 2) AS `Gastric Banding`,
    SUM(op.OP1OPVerfahren = 3) AS `Roux-en-Y Gastric Bypass`,
    SUM(op.OP1OPVerfahren = 99) AS `Anderes OP-Verfahren`,
    SUM(op.OP1OPVerfahren LIKE '%') AS `Summe`

    FROM ods02.dat_patient p
    LEFT OUTER JOIN ods02.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN '1950-01-01' AND '2019-12-31'
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods02.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

    UNION ALL

    SELECT
    COUNT(IF(op.OP1OPVerfahren = 0, 1, NULL)) AS `Keine Operation durchgeführt`,
    SUM(op.OP1OPVerfahren = 1) AS `Bioenterics Intragastric Ballon (BIB)`,
    SUM(op.OP1OPVerfahren = 2) AS `Gastric Banding`,
    SUM(op.OP1OPVerfahren = 3) AS `Roux-en-Y Gastric Bypass`,
    SUM(op.OP1OPVerfahren = 99) AS `Anderes OP-Verfahren`,
    SUM(op.OP1OPVerfahren LIKE '%') AS `Summe`

    FROM ods03.dat_patient p
    LEFT OUTER JOIN ods03.dat_optherapie op ON op.patID = p.ID

    WHERE op.OP1Datum BETWEEN '1950-01-01' AND '2019-12-31'
    AND p.Testzwecke = 0
    AND NOT EXISTS (SELECT 1
        FROM ods03.dat_optherapie op2
        WHERE op2.patID = p.ID AND op2.revision > op.revision
    )

) whatever;


这里的COUNT（...）语句仅显示它等于SUM（...）-结果是相同的，我什至可以对子查询中的所有总和使用COUNT（...）语句。

我感谢所有试图帮助我解决问题的人。

关于mysql - 如何在x个相同的MySQL SUM表上求和？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/55189275/

10-16 18:33
Powered by LMLPHP ©2024 sum 0.032204