MySql使用临时表合并查询

CREATE TEMPORARY TABLE temp_articleCount 

SELECT 

    COUNT(*) AS articleCount, 

    typeCategoryID 

FROM article 

GROUP BY typeCategoryID;

-- 关联查询并选择需要的字段

SELECT 

    T.typeCategoryID,

    T.typeCategoryName,

    C.articleCount

FROM temp_articleCount AS C 

INNER JOIN typecategory AS T ON T.typeCategoryID = C.typeCategoryID;

drop TABLE temp_articleCount