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

1 vote235 views10 answers
Stack overflow
SQL
2 votes269 views1 answer
Power query concatenate
SQL
0 vote247 views2 answers
Mysql multiply
SQL
1 vote285 views1 answer
Mysql last year
SQL
2 votes305 views1 answer
How to check if a row is null in sql
SQL
0 vote250 views1 answer
Check psql validity function
SQL
0 vote271 views1 answer
Sql convert unix time to date
SQL
3 votes271 views1 answer
DB: in eloquent using sql
SQL
3 votes258 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote258 views1 answer
Describe table in sql
SQL