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 vote145 views1 answer
Oracle index hint
SQL
2 votes136 views1 answer
Oracle create directory
SQL
1 vote147 views1 answer
Oracle undo usage per session
SQL
11 votes165 views2 answers
Sql rank
SQL
0 vote152 views1 answer
List in one column mysql
SQL
6 votes156 views1 answer
T-sql test if table exists
SQL
0 vote148 views1 answer
Mysql url
SQL
0 vote212 views1 answer
Get last inserted primary key
SQL
0 vote148 views1 answer
Add multiple field in table sql
SQL
15 votes154 views2 answers
Sql order by multiple columns
SQL