/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 vote136 views1 answer
In query in sql
SQL
0 vote103 views1 answer
Uuid sqlalcomany
SQL
0 vote230 views1 answer
Sql change a colum to unique
SQL
0 vote109 views1 answer
Postgresql on conflict pair
SQL
2 votes105 views2 answers
Mysql user access to database
SQL
2 votes142 views3 answers
How to replace null values in sql
SQL
4 votes119 views3 answers
Rename table column postgresql
SQL
0 vote114 views1 answer
Install sql server windows 10
SQL
0 vote107 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
13 votes108 views2 answers
Oracle select into and inner join
SQL