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

24 votes117 views5 answers
List mysql users
SQL
0 vote112 views1 answer
Mysql select all where count more than"
SQL
1 vote122 views3 answers
How to reset id column in sql server
SQL
0 vote109 views1 answer
Syntax for changing column size in mysql
SQL
1 vote184 views1 answer
Mysql monthname
SQL
1 vote114 views4 answers
Fatal database postgres does not exist
SQL
0 vote154 views5 answers
Select concat alter table mysql
SQL
0 vote161 views1 answer
Mysql show schema
SQL
0 vote117 views1 answer
To change the database owner in SQL server
SQL
0 vote109 views1 answer
Get who is hired in specific month in sql
SQL