/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

9 votes307 views5 answers
Sql delete duplicate rows but keep one
SQL
6 votes291 views5 answers
Mysql get last insert id
SQL
3 votes297 views1 answer
Sql is not like
SQL
6 votes275 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
3 votes288 views1 answer
Two selects in one query
SQL
0 vote302 views1 answer
Arithmetic expression in sql
SQL
1 vote279 views1 answer
Oracle list constraints
SQL
0 vote259 views1 answer
Mysql create table columns with spaces
SQL
24 votes285 views5 answers
Sql server insert into select
SQL
0 vote294 views2 answers
How to set global time_zone in mysql
SQL