1 需求: 将一段时间按月拆分 一个实例: (2022/08/22 - 2022/08/27) 将这个时间端,按日拆开来,并按日均摊度量1 MYSQL 8.0+ with recursive cte(ORDER_NO, CREATE_DATE, END_DATE,DATE_LABEL) as ( select 'VX123' AS ORDER_NO, date_format('2022-08-22 2