/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 vote391 views1 answer
Oracle create program if not exists
SQL
0 vote338 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
8 votes502 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote359 views1 answer
Update having mysql
SQL
19 votes357 views6 answers
What is mySQL
SQL
0 vote321 views1 answer
Get all employees if name ends with in sql
SQL
3 votes323 views1 answer
Difference sql vs mysql
SQL
0 vote342 views1 answer
Oracle query archivemode
SQL
4 votes338 views2 answers
Sql table
SQL
0 vote337 views1 answer
Like and not like together in sql
SQL