Mysql刷题笔记 12.24 每条记录每次增加30分钟，增加3次

-- 12.24 希望每条记录每次增加30分钟，增加3次
T1224
+------+---------------------+
| ID   | EndTime             |
+------+---------------------+
|    1 | 2020-05-26 16:00:00 |
|    2 | 2020-05-26 17:30:00 |
+------+---------------------+

结果
+------+---------------------+-----+
| id   | endtime             | num |
+------+---------------------+-----+
|    1 | 2020-05-26 16:00:00 |   1 |
|    1 | 2020-05-26 16:30:00 |   2 |
|    1 | 2020-05-26 17:00:00 |   3 |
|    1 | 2020-05-26 17:30:00 |   4 |
|    2 | 2020-05-26 17:30:00 |   1 |
|    2 | 2020-05-26 18:00:00 |   2 |
|    2 | 2020-05-26 18:30:00 |   3 |
|    2 | 2020-05-26 19:00:00 |   4 |
+------+---------------------+-----+

SELECT t1.id, DATE_ADD(t1.endtime,INTERVAL 30*(num-1) MINUTE) endtime, t2.num
FROM t1224 t1 inner join
(SELECT 1 num UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) t2
ORDER BY t1.id,endtime;