/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 vote187 views2 answers
Identity syntax in sql
SQL
0 vote169 views2 answers
How to find sql server agent jobs related to a database
SQL
2 votes189 views1 answer
Ifnull postgres
SQL
1 vote197 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote154 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote174 views1 answer
Sql change column in existing table
SQL
0 vote180 views1 answer
Select count concat string sql server
SQL
0 vote190 views2 answers
Generate sql trigger through ef migration
SQL
5 votes165 views2 answers
Oracle show procedures
SQL
1 vote175 views1 answer
Set autoincrement to 0
SQL