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

3 votes329 views1 answer
Dbms_scheduler drop_job
SQL
5 votes309 views3 answers
Truncate function in sql oracle
SQL
5 votes306 views1 answer
Sql first day of current year
SQL
3 votes352 views1 answer
Only join in sql
SQL
0 vote321 views1 answer
Sql anywhere create procedure
SQL
16 votes336 views3 answers
Tsql rename column name
SQL
0 vote278 views1 answer
Check if has alpha characters sql
SQL
1 vote343 views3 answers
How to filter repeated same result using sql query
SQL
0 vote353 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote337 views1 answer
TSQL convert csv to table
SQL