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 vote291 views1 answer
ORA-01400
SQL
0 vote201 views2 answers
Sql server select where date
SQL
0 vote209 views1 answer
Yesql
SQL
0 vote199 views1 answer
Sql server express download
SQL
0 vote207 views3 answers
Group_concat sql server
SQL
0 vote197 views1 answer
Oracle drop default value
SQL
4 votes187 views1 answer
Oracle show errors compilation
SQL
4 votes221 views1 answer
List tables sqlite
SQL
0 vote266 views1 answer
Scheduled mysql database backup in linux
SQL
2 votes185 views2 answers
How to get capital letter first in sql
SQL