/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 vote204 views1 answer
Oracle drop job if exists
SQL
0 vote207 views1 answer
Postgresql linux password
SQL
0 vote178 views1 answer
Resulting Query
SQL
0 vote262 views1 answer
Manage Database in MySQL
SQL
0 vote188 views1 answer
Postgres read table structure
SQL
5 votes186 views1 answer
Oracle ora-00054 causes
SQL
1 vote237 views1 answer
Postgresql append array
SQL
0 vote218 views1 answer
Create tables from xsd to sql server database c#
SQL
42 votes282 views6 answers
Rename table sql server
SQL
0 vote204 views1 answer
How to close external sql connection in laravel
SQL