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

10 votes236 views5 answers
Mysql create user
SQL
0 vote244 views1 answer
Oracle list partitions
SQL
0 vote244 views1 answer
SQL division of an integer by another integer get float CAST
SQL
3 votes248 views1 answer
APEX elapsed time
SQL
0 vote250 views1 answer
Example database query
SQL
0 vote239 views1 answer
Sql reverse order of results
SQL
0 vote215 views1 answer
Postgres float to int
SQL
0 vote234 views1 answer
My sql data file extention
SQL
1 vote211 views1 answer
Sqlite check if row exists
SQL
0 vote229 views1 answer
What is ssrs and ssis in sql server
SQL