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 vote150 views1 answer
Sql quary intervewi question
SQL
24 votes145 views6 answers
Rename a column in sql server
SQL
3 votes191 views1 answer
Oracle detect invalid password
SQL
0 vote172 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote150 views3 answers
Select random sql
SQL
13 votes161 views3 answers
Insert mysql ifile nto database
SQL
0 vote146 views2 answers
Postgresql change user role grant
SQL
0 vote152 views1 answer
Sqlite update only if greater
SQL
0 vote129 views1 answer
Jooq finding lastest value in table
SQL
0 vote156 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL