/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

57 votes471 views6 answers
Mysql alter table add column
SQL
1 vote306 views1 answer
Mysql last year
SQL
0 vote248 views1 answer
Update row in sqlite python
SQL
0 vote260 views1 answer
Drop check command
SQL
0 vote319 views1 answer
Sparql list all graphs
SQL
0 vote277 views1 answer
Mysql set column equal to another automatic
SQL
0 vote261 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote275 views2 answers
Starting mysql service from mac
SQL
3 votes278 views2 answers
Brew restart mysql
SQL
0 vote273 views1 answer
Output table plsql
SQL