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

13 votes117 views4 answers
Mysql get last row
SQL
7 votes154 views1 answer
Show line number in sql server
SQL
0 vote118 views1 answer
Sql show all users
SQL
0 vote120 views1 answer
C# check if mysql query modified rows
SQL
0 vote117 views1 answer
Sql contains vs like
SQL
0 vote118 views1 answer
Oracle get running queries
SQL
2 votes119 views1 answer
How to make insert script from table in SQL server
SQL
2 votes110 views1 answer
Pandas to sql index
SQL
1 vote118 views1 answer
Sql server read uncommitted
SQL
0 vote126 views1 answer
Convert .mdf to .bak
SQL