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

0 vote248 views1 answer
Sql count matching group by
SQL
0 vote195 views1 answer
Create database like
SQL
0 vote193 views1 answer
Mysql query with sql to get the next row
SQL
0 vote204 views1 answer
Oracle show grants on table
SQL
0 vote198 views1 answer
Sql delete dastabase
SQL
0 vote245 views5 answers
Right join
SQL
1 vote201 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote184 views1 answer
Normalization in database 2nd normal form
SQL
21 votes190 views6 answers
Docker run mysql
SQL
15 votes200 views4 answers
Pl sql
SQL