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 vote272 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote252 views1 answer
SQL get max per id
SQL
3 votes286 views1 answer
Postgres count distinct
SQL
4 votes297 views1 answer
Sql select limit range
SQL
4 votes271 views1 answer
Phone number sql
SQL
2 votes262 views1 answer
Plsql block
SQL
0 vote284 views1 answer
Sql select column name like from multiple tables
SQL
0 vote271 views2 answers
Search stored procedures by name
SQL
0 vote259 views1 answer
Mysql add comment to column
SQL
0 vote279 views4 answers
Postgresql between month
SQL