MySQL把时间区间拆分为多行数据

SELECT dt1, dt2 FROM(
SELECT
@dt1 as dt1, 
@dt1 := @dt1 + INTERVAL 1 DAY, 
@dt := @dt1 - INTERVAL 1 DAY,
CASE WHEN @dt1 <= @dt2 THEN @dt ELSE  @dt2 END as dt2
FROM( SELECT @dt1:=CAST('2018-08-01' as date), @dt2:=CAST('2018-08-31' as date) ) _x,
information_schema.columns A
WHERE @dt1 <= @dt2
) A

复制直接使用