Mysql insert generate serie

WITH RECURSIVE sequence AS (
    SELECT 1 AS level
    UNION ALL
    SELECT level + 1 AS value
    FROM sequence
    WHERE sequence.level < 10
)
SELECT level
FROM sequence;

Mysql row generator

SELECT  @curRow := @curRow + 1 AS row_number
FROM    sometable 
JOIN    (SELECT @curRow := 0) r
WHERE   @curRow<100;

Source: stackoverrun.com

Similar codes

1 vote70 views1 answer
Import in mysql without a software
SQL
0 vote88 views2 answers
Select limit ms sql
SQL
0 vote115 views1 answer
WHERE not regex in SQL
SQL
0 vote118 views1 answer
Pl/pgsql declare variable
SQL
0 vote102 views1 answer
Fill up postgres db
SQL
0 vote145 views2 answers
Mysql cast to varchar
SQL
2 votes104 views1 answer
No data found oracle
SQL
0 vote99 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote134 views1 answer
Mysql error codeigniter
SQL
0 vote50 views1 answer
Copy table dbeaver
SQL