/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 vote193 views1 answer
How to test for sql injection
SQL
1 vote198 views1 answer
Postgres power
SQL
1 vote195 views1 answer
Drop function
SQL
5 votes194 views2 answers
Oracle list columns schema
SQL
0 vote188 views1 answer
Oracle last connection
SQL
0 vote187 views1 answer
Mysql group by derived column
SQL
0 vote187 views1 answer
How to check replication lag in mySQL
SQL
7 votes198 views1 answer
Mysql remote connection command line
SQL
1 vote205 views4 answers
Get week day from date in sql
SQL
12 votes203 views4 answers
Mysql get date difference in hours
SQL