/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

1 vote177 views1 answer
Apex run 404
SQL
0 vote149 views1 answer
Sqlite3 get data from table c
SQL
0 vote122 views2 answers
Android sqlite query join
SQL
1 vote153 views1 answer
Show per page table in xampp
SQL
0 vote150 views1 answer
Sql tablo hangi sp de
SQL
0 vote153 views1 answer
How to use lower case in mysql
SQL
1 vote153 views1 answer
Oracle drop temporary table
SQL
15 votes147 views2 answers
How to drop database name in postgresql
SQL
1 vote152 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote152 views1 answer
Mysql get first 2 characters of string
SQL