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

1 vote174 views1 answer
Backup mysql data only
SQL
0 vote187 views2 answers
Get item by composite primary key mysql
SQL
2 votes175 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
1 vote166 views2 answers
String to date postgres
SQL
3 votes131 views1 answer
V$session not found in oracle
SQL
0 vote203 views1 answer
Renommer schema sql
SQL
0 vote172 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote172 views1 answer
Mysql get longest string in column
SQL
5 votes188 views1 answer
Oracle list days between two dates
SQL
2 votes219 views1 answer
Datetrunc
SQL