H RECURSIVE tbl AS (
 SELECT CAST(NULL AS CHAR(50)) AS col
 UNION SELECT "THIS NEVER SHOWS UP" AS col FROM tbl
)  
SELECT * FROM tbl;
+---------------------+
| col                 |
+---------------------+
| NULL                |
| THIS NEVER SHOWS UP |
+---------------------+

URL: https://mariadb.com/kb/en/recursive-common-table-expressions-overview/https://mariadb.com/kb/en/recursive-common-table-expressions-overview/