/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

4 votes144 views4 answers
Mysql get date from datetime
SQL
3 votes120 views1 answer
Delete all content in table mysql
SQL
6 votes141 views4 answers
Mysql group by date
SQL
0 vote130 views1 answer
Psql select * from table
SQL
0 vote160 views1 answer
Stop psql server windows
SQL
1 vote168 views1 answer
Postgresql blocked on mac
SQL
1 vote142 views1 answer
Full sql mode
SQL
0 vote134 views1 answer
Get last three characters in mysql column
SQL
1 vote123 views1 answer
Sql headers delphi
SQL
3 votes139 views2 answers
How to open postgresql in windows
SQL