示例表如下:,
CREATE TABLE TIMEOFF_INFO (
TIMEOFF_ID INT PRIMARY KEY,
TIMEOFF_BEGIN DATE NOT NULL,
TIMEOFF_END DATE NOT NULL
)
以及下面的示例行,
+------------+---------------+-------------+
| timeoff_id | timeoff_begin | timeoff_end |
+------------+---------------+-------------+
| 1 | 2021-10-01 | 2021-10-02 |
+------------+---------------+-------------+
| 2 | 2021-11-15 | 2021-11-15 |
+------------+---------------+-------------+
| 3 | 2021-12-18 | 2021-12-20 |
+------------+---------------+-------------+
我想得到的是将上表转换为下表,这样我就可以使用范围内的每个日期加入。
2021-10-01 (id: 1's begin date)
2021-10-02 (id: 1's end date)
2021-11-15 (id: 2's begin and end date)
2021-12-18 (id: 3's begin date)
2021-12-19
2021-12-20 (id: 3's end date)
有没有办法将单行中的日期范围扩展到一系列日期行?
