/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 vote197 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote183 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
1 vote168 views1 answer
How to find median of a column sql
SQL
44 votes291 views4 answers
Mysql alter table add column first
SQL
1 vote136 views1 answer
Mysql show attributes of a table
SQL
10 votes184 views3 answers
Sql select between two dates
SQL
11 votes199 views2 answers
Set default column value sql
SQL
0 vote255 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
15 votes178 views2 answers
How to know the username of postgresql
SQL
0 vote196 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL