/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 vote145 views4 answers
Postgresql between month
SQL
2 votes151 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
8 votes190 views6 answers
Insert command in sql
SQL
0 vote171 views1 answer
Oracle current date minus 1 day
SQL
0 vote178 views1 answer
Jooq replace
SQL
0 vote165 views1 answer
How to remove quotes from a string in ssis load file
SQL
5 votes150 views2 answers
Mysql import gzip db
SQL
0 vote147 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote138 views1 answer
Django how to get query result count
SQL
1 vote178 views1 answer
Continue in sql
SQL