/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 vote169 views1 answer
Power query datetime to date
SQL
7 votes171 views1 answer
Mysql iif
SQL
1 vote124 views1 answer
Athena query timestamp greater than
SQL
1 vote163 views1 answer
Mysql random limit 1
SQL
0 vote168 views1 answer
Create a view in sqlite
SQL
7 votes161 views3 answers
Sql get last inserted row
SQL
0 vote172 views1 answer
Drop column from local database postgres pgadmin
SQL
11 votes180 views2 answers
How to import mysql database command line
SQL
0 vote184 views1 answer
Hallo
SQL
0 vote169 views1 answer
Exit psql
SQL