/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 vote210 views2 answers
Oracle list service names
SQL
3 votes215 views1 answer
Sql multi column index performance
SQL
0 vote219 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote212 views1 answer
Mysql where in maintain order
SQL
1 vote200 views2 answers
Sql where keyword
SQL
0 vote210 views1 answer
Increase speed of like queries postgres
SQL
-2 votes208 views4 answers
How to get max salary in each department in sql
SQL
0 vote221 views1 answer
Psotgres multiple values
SQL
0 vote223 views1 answer
Shrink database file in sql server
SQL
6 votes240 views3 answers
Rename column ORACLE
SQL