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 vote126 views4 answers
Sequelize migration default value
SQL
0 vote138 views3 answers
Query string not ending with with vowels
SQL
0 vote144 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote138 views3 answers
Sql select statements
SQL
0 vote131 views1 answer
Big table in mysql
SQL
0 vote116 views1 answer
Cara menampilkan user di mysql terminal
SQL
18 votes124 views4 answers
Foreign key mySql
SQL
1 vote131 views1 answer
Psql lst trigger
SQL
0 vote154 views1 answer
Postgresql port 5432 not open
SQL
1 vote121 views1 answer
Mysql count all table rows
SQL