如何从mysql获取数据并在几周内将它们分组，还按月分开 [英] How to get data from mysql and group them in weeks, also separating by month

问题描述

我有mysql数据库，并且充满了超过2年的数据.如何进行查询才能获得如下结果?

I have mysql database and is full of over 2 years of data. How can I make a query in a way that it will get the result as below?:

January
   Week 1
      ...
      data rows here
      ....
   Week 2
      ...
      ...
   Week 3
      ...
      ...
   Week 4
      ...
      ...

February (same as above)

这些是字段结构:

- date (in yyyy-mm-dd format)
- job (integer autoincrement)
- person (varchar)

推荐答案

尝试一下，它将生成与您所需的输出非常相似的输出

Try this, it will generate output pretty similar to one required by you

SELECT MONTH(date) AS MONTH, WEEK(date) AS WEEK, DATE_FORMAT(date, %Y-%m-%d) AS DATE, job AS JOB, person AS PERSON GROUP BY WEEK(date);

这篇关于如何从mysql获取数据并在几周内将它们分组，还按月分开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！