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 vote279 views4 answers
Database stuck at restoring state
SQL
0 vote266 views1 answer
How many columns can be used for creating index?
SQL
0 vote297 views1 answer
Query by column for substring sql
SQL
0 vote303 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
3 votes284 views1 answer
Select without null values sql
SQL
0 vote275 views1 answer
Print orcale
SQL
1 vote301 views1 answer
Drop column if exists sql server
SQL
13 votes274 views2 answers
Check if value is null mysql
SQL
0 vote281 views1 answer
Insert into select with group by
SQL
0 vote307 views1 answer
Dump only data
SQL