MySQL 에서 재귀 쿼리 사용하기

WITH RECURSIVE T_TMP1 AS (
   SELECT NOW()  AS `DATE`
)
, T_TMP2 AS (
   SELECT "TEST" AS `DATE`
)

SELECT A.DATE AS `DATE` FROM T_TMP1 A
 UNION ALL
SELECT B.DATE AS `DATE` FROM T_TMP2 B
;

+---------------------+
| DATE                |
+---------------------+
| 2020-09-06 01:21:58 |
| TEST                |
+---------------------+
2 rows in set (0.00 sec)