/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 vote346 views1 answer
Sql cmd no truncate
SQL
0 vote333 views1 answer
Create query in where clasue
SQL
0 vote323 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote322 views1 answer
Convert sql server guid to varbinary
SQL
1 vote353 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote356 views2 answers
Snowflake alter column data type
SQL
0 vote328 views1 answer
List all functions and procedures in postgres query
SQL
0 vote325 views1 answer
Drop all triggers oracle
SQL
0 vote323 views1 answer
Character count sql
SQL
0 vote335 views1 answer
Mysql repair a table
SQL