/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 vote99 views1 answer
Search db for table name
SQL
1 vote121 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote59 views0 answer
SQL
0 vote108 views1 answer
Mysql max number not returning correct value
SQL
0 vote130 views1 answer
Mysqldump: error:
SQL
3 votes94 views2 answers
Oracle synonym
SQL
0 vote76 views1 answer
Oracle sysdba connect as another user
SQL
-1 vote53 views3 answers
Ubuntu install mssql
SQL
4 votes99 views1 answer
Select nls_date_format
SQL
8 votes113 views1 answer
How to check mysql version in xampp
SQL