/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

3 votes464 views1 answer
Oracle nextval insert
SQL
0 vote351 views1 answer
Sum sqlserver
SQL
0 vote320 views0 answer
SQL
4 votes402 views3 answers
Sql find second highest salary employee
SQL
0 vote394 views2 answers
How to get max from each department in sql
SQL
9 votes388 views3 answers
Mysql run sql file
SQL
0 vote356 views1 answer
Hive batch drop table
SQL
0 vote378 views1 answer
Renombrar tabla mysql
SQL
3 votes332 views1 answer
V$session not found in oracle
SQL
5 votes357 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL