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 vote222 views1 answer
Savepoint mysql script
SQL
0 vote150 views1 answer
Ms sql print more than 1 variable
SQL
0 vote195 views1 answer
Sql server remove 0 from left
SQL
0 vote190 views1 answer
Partitioning in oracle-base
SQL
0 vote194 views1 answer
Select in select sql
SQL
0 vote203 views1 answer
Mysql_error replacement
SQL
0 vote224 views1 answer
Oracle list datafiles
SQL
8 votes218 views2 answers
Grant all privileges database postgres to user
SQL
0 vote192 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote184 views1 answer
Error code 1241 mysql
SQL