/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 vote253 views1 answer
Sqlite woth cmake
SQL
1 vote153 views2 answers
Sql convert datetime to year month
SQL
1 vote139 views1 answer
Set all the vluses in calumn in sql to false
SQL
3 votes154 views2 answers
Having in mysql
SQL
1 vote143 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote169 views3 answers
Postgresql crete view
SQL
0 vote157 views1 answer
Connect to nginx server mysql remotly
SQL
2 votes159 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote158 views1 answer
Duplix print in Smartforms
SQL
11 votes150 views1 answer
How to get ddl for materialized view
SQL