/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 vote329 views1 answer
Where to locate set password for mysql
SQL
1 vote321 views1 answer
Mysql query bulk insert
SQL
1 vote349 views2 answers
Oracle difference between two dates in seconds
SQL
-1 vote332 views1 answer
Module operator in oracle sql
SQL
1 vote328 views1 answer
List all triggers in SQL Server
SQL
1 vote326 views1 answer
Mysql dump specific tables
SQL
19 votes333 views6 answers
What is mySQL
SQL
3 votes337 views5 answers
Foreign keys
SQL
51 votes694 views6 answers
Installing mysql on ubuntu
SQL
0 vote315 views1 answer
Sql server convert date to weekday
SQL