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 votes213 views4 answers
What is sql
SQL
0 vote203 views1 answer
Mysql streaming example
SQL
0 vote193 views1 answer
Increment id in mysql
SQL
9 votes212 views3 answers
Sql delete where in
SQL
1 vote212 views1 answer
How to check the mysql version mac
SQL
2 votes231 views1 answer
Import large .sql files into lampp
SQL
0 vote196 views1 answer
Sql get month from date
SQL
0 vote200 views1 answer
Call scalar valued function sql
SQL
4 votes157 views1 answer
And or sql order of operations
SQL
7 votes200 views1 answer
Minecraft forge server host
SQL