/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

0 vote428 views1 answer
Mysql convert charset
SQL
3 votes345 views1 answer
RENAME table pl sql
SQL
0 vote360 views1 answer
Select multiple row from primary key sql
SQL
0 vote354 views1 answer
Mysql update table from select on another table
SQL
0 vote318 views1 answer
Sql requete number pair
SQL
0 vote361 views1 answer
Get create sql of hibernqte entity
SQL
19 votes358 views6 answers
Create table sqlite
SQL
0 vote354 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote336 views1 answer
Oracle call a function in a insert statement
SQL
2 votes396 views2 answers
Mysql write into table
SQL