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

2 votes348 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote311 views1 answer
Call function sql oracle
SQL
1 vote315 views1 answer
Change table to innodb mysql
SQL
9 votes340 views5 answers
Laravel to sql
SQL
16 votes315 views4 answers
Mysql import from sql file
SQL
0 vote329 views1 answer
Sql server set complex constraints
SQL
2 votes330 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
50 votes403 views6 answers
Sql duplicate rows
SQL
3 votes324 views2 answers
To_char oracle
SQL
0 vote384 views1 answer
Why do we need data structure in sql
SQL