/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

34 votes280 views6 answers
Install mysql client ubuntu
SQL
1 vote268 views2 answers
Populate sql table with random data
SQL
2 votes293 views1 answer
Mysql create user with remote access
SQL
0 vote264 views1 answer
Change data type in mysql
SQL
0 vote265 views1 answer
Sql query to select records entered in last 24 hours
SQL
4 votes293 views1 answer
Postgresql list sequences
SQL
18 votes269 views3 answers
Mysql number format
SQL
5 votes275 views1 answer
Find table from column name in sql
SQL
2 votes279 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote283 views1 answer
Incompatible sql_mode=only_full_group_by
SQL