mysql workbench cte recursive code example
Example: mysql insert into select with recursive
INSERT cte_populated(id)
WITH RECURSIVE int_seq AS (
SELECT 1 AS val
UNION ALL
SELECT val + 1
FROM int_seq
WHERE val < 10
)
SELECT int_seq.val FROM int_seq;