/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

2 votes249 views1 answer
Import database in mysql command line xampp
SQL
0 vote272 views1 answer
Mysql subtract month from timestamp
SQL
0 vote330 views1 answer
Oracle calculate statistics on partition
SQL
3 votes260 views1 answer
Select nextval from sequence sql
SQL
0 vote257 views1 answer
Postgressql uuid
SQL
28 votes292 views6 answers
Sql update
SQL
0 vote274 views1 answer
Datagrip execute procedure
SQL
0 vote234 views1 answer
Sqlite3 now
SQL
0 vote267 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote300 views1 answer
How to get table id sequence postgres
SQL