/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

34 votes202 views6 answers
Alter table add foreign key mysql
SQL
1 vote155 views1 answer
Add many column to sap iq table
SQL
2 votes143 views1 answer
How to add where command in update comand with joins
SQL
1 vote150 views1 answer
Set autoincrement to 0
SQL
1 vote176 views1 answer
Convert to hexadecimal sql
SQL
0 vote191 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote169 views2 answers
Postgres having
SQL
1 vote188 views1 answer
Set statiscis on in sql server
SQL
12 votes160 views1 answer
Psql drop column
SQL
0 vote143 views1 answer
Mysql autoincrement valor inicial
SQL