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 vote179 views1 answer
Oracle enable job
SQL
0 vote196 views1 answer
Ajouter une clé etrangere mysql
SQL
4 votes193 views2 answers
Truncate oracle
SQL
1 vote187 views2 answers
One to one and one to many relationship
SQL
10 votes208 views2 answers
Select nextval from sequence oracle
SQL
0 vote190 views1 answer
SQL Server rename foreign key constraint
SQL
6 votes233 views3 answers
Check if string contains substring sql
SQL
0 vote171 views1 answer
Sql remove non numeric characters
SQL
0 vote431 views1 answer
Create pl/sql stored procedure
SQL
0 vote187 views1 answer
User, group, or role 'open' already exists in the current database.
SQL