/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

6 votes216 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote241 views1 answer
Mysql query to select the highest value
SQL
-2 votes216 views1 answer
No module named '_sqlite3
SQL
1 vote214 views3 answers
Update from select sqlite
SQL
2 votes223 views1 answer
How to show the whole table in sql
SQL
0 vote249 views1 answer
"Hello User Name"
SQL
3 votes223 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote210 views1 answer
Oracle procedure chain step
SQL
0 vote211 views1 answer
Sp in sql server
SQL
0 vote206 views1 answer
Pgadmin see indexes
SQL