/SQL/Mysql insert into select with recursive

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;

Source: stackoverflow.com

Similar codes

1 vote73 views1 answer
Athena query timestamp greater than
SQL
17 votes125 views2 answers
T_sql contains
SQL
0 vote122 views1 answer
Convert int to varchar sql
SQL
25 votes115 views5 answers
Date in mysql
SQL
1 vote120 views1 answer
Multiple count in sql
SQL
0 vote110 views1 answer
Mysql function variable
SQL
2 votes123 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote116 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
1 vote242 views1 answer
Import sql file from laravel
SQL
0 vote124 views1 answer
Mysql update even / odd rows
SQL