/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 vote183 views2 answers
Mysql update two tables at once
SQL
5 votes194 views1 answer
Sort order on two columns sql
SQL
1 vote264 views3 answers
Date_add mysql
SQL
0 vote187 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote177 views2 answers
Mysql password error create datbase
SQL
6 votes190 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote176 views1 answer
Mysql isshow
SQL
0 vote180 views1 answer
Create table Statement Syntax in SQL Server
SQL
2 votes186 views1 answer
Mysql increment value by 1 in update
SQL
0 vote229 views1 answer
Mariadb change column type
SQL