https://blog.csdn.net/wxc20062006/article/details/51899569
1:需求:我需要查询某个bid的每个分类的文章数量,没有分类的文章就展示为0 的结果集返回:
具体数据库表结构:
/*
文章表
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for articles
-- ----------------------------
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '文章标识id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题',
`summary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章摘要',
`read_count` int