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 vote315 views1 answer
Sqlite3_open_v2
SQL
1 vote292 views1 answer
Operator does not exist: integer = text
SQL
4 votes291 views2 answers
SELECT table_name FROM user_tables;
SQL
11 votes278 views2 answers
Sql rank
SQL
1 vote291 views5 answers
Sql 2nd highest salary
SQL
5 votes303 views2 answers
Mysql import gzip db
SQL
0 vote327 views1 answer
Transaction and commit trong sql server
SQL
3 votes286 views1 answer
Ms sql skip take
SQL
3 votes279 views2 answers
Mysql time
SQL
18 votes302 views6 answers
Creating table in MySQL
SQL