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

26 votes360 views2 answers
Mysql workbench download
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL
25 votes354 views4 answers
Metadata
SQL
7 votes378 views2 answers
Phpmyadmin change password
SQL
0 vote353 views2 answers
Sql query for getting details by id
SQL
16 votes377 views1 answer
Mssql int max value
SQL
0 vote339 views1 answer
IIF
SQL
0 vote378 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote391 views1 answer
Contraint default SQL
SQL
2 votes341 views1 answer
Mysql cannot delete or update a parent row
SQL