/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 vote116 views1 answer
Sql count null values in all columns
SQL
7 votes103 views1 answer
Sql management studio display line numbers
SQL
3 votes125 views1 answer
Oracle function return
SQL
3 votes140 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
6 votes129 views4 answers
Mysql group by date
SQL
1 vote111 views1 answer
Add sequence postgres
SQL
0 vote124 views1 answer
Creation d'un trigger sql
SQL
0 vote142 views1 answer
In query in sql
SQL
1 vote130 views1 answer
Sql how to replace full stop
SQL
1 vote117 views1 answer
Tsql find foreign key references
SQL