/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

2 votes183 views1 answer
Oracle sql day of month from date
SQL
1 vote228 views1 answer
Sql select row with max date
SQL
1 vote198 views2 answers
Oracle replace
SQL
12 votes229 views4 answers
How to drop all tables in postgresql
SQL
0 vote200 views1 answer
Psql attribute cannot login
SQL
0 vote174 views1 answer
Mql5 list all available symbols
SQL
1 vote203 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote182 views1 answer
Generate random & unique mysql string
SQL
0 vote199 views1 answer
Sql cnvert bit to nvarchar
SQL
10 votes203 views4 answers
How to alter table name in mysql
SQL