/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 vote231 views1 answer
Sql tablo hangi sp de
SQL
0 vote199 views1 answer
Oracle select partition
SQL
1 vote229 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote331 views1 answer
Alter table name including schema
SQL
1 vote196 views3 answers
Mysql connection string
SQL
0 vote198 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote193 views1 answer
Mysql with
SQL
0 vote216 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote211 views1 answer
Convert polygon to text in mysql
SQL
0 vote214 views1 answer
Delete hangfire retries list
SQL