/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 vote141 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote170 views1 answer
Suhaib
SQL
8 votes160 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote140 views1 answer
Php mysqli install
SQL
0 vote139 views1 answer
Oracle create table auto generated primary key
SQL
0 vote131 views1 answer
Oracle last character of string
SQL
1 vote135 views1 answer
Loading local data is disabled mysql
SQL
0 vote131 views1 answer
Distinct data types in a table sql query
SQL
1 vote158 views2 answers
Mysql extract number from string
SQL
0 vote127 views1 answer
Sql random decimal
SQL