mysql按周统计某维度指标（week与weekday）

最新推荐文章于 2024-07-08 17:47:17 发布

qq_38824458

最新推荐文章于 2024-07-08 17:47:17 发布

阅读量1.3k

点赞数 2

文章标签： mysql

本文链接：https://blog.csdn.net/qq_38824458/article/details/125616600

版权

本文介绍了如何在MySQL中利用week()和weekday()函数按周统计某个维度的指标，通过创建表格和实际操作展示统计每周做题数量的方法，并详细解释了这两个函数的用法和参数含义。

摘要由CSDN通过智能技术生成

一、创建表格

二、实现根据字段date，统计每周做题的数量

三、涉及函数解释

1、week(date,mode)

2、weekday(date)

3、DATE_ADD(date,INTERVAL expr unit)

一、创建表格

drop table if  exists `question_practice_detail`;
CREATE TABLE `question_practice_detail` (
`id` int NOT NULL,
`device_id` int NOT NULL,
`question_id`int NOT NULL,
`result` varchar(32) NOT NULL,
`date` date NOT NULL
);
INSERT INTO question_practice_detail VALUES(1,2138,111,'wrong','2021-05-03');
INSERT INTO question_practice_detail VALUES(2,3214,112,'wrong','2021-05-09');
INSERT INTO question_practice_detail VALUES(3,3214,113,'wrong','2021-06-15');
INSERT INTO question_practice_detail VALUES(4,6543,111,'right','2021-08-13');
INSERT INTO question_practice_detail VALUES(5,2315,115,'right','2021-08-13');
INSERT INTO question_practice_detail VALUES(6,2315,116,'right','2021-08-14');
INSERT INTO question_practice_detail VALUES(7,2315,117,'wrong','2021-08-15');
INSERT INTO question_practice_detail VALUES(8,3214,112,'wrong','2021-05-09');
INSERT INTO question_practice_detail VALUES(9,3214,113,'wrong','2021-08-15');
INSERT INTO question_practice_detail VALUES(10,6543,111,'right','2021-08-13');
INSERT INTO question_practice_detail VALUES(11,2315,115,'right','2021-08-13');
INSERT INTO question_practice_detail VALUES(12,2315,116,'right','2021-08-14');
INSERT INTO question