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 vote302 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote292 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote266 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote317 views2 answers
Postgres isnull
SQL
0 vote296 views1 answer
Mysql best varchar length size
SQL
0 vote345 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote292 views1 answer
Login failed for user sql server
SQL
0 vote265 views1 answer
Left join in codeigniter query builder
SQL
0 vote272 views1 answer
How to create an SQL save method in ruby
SQL
34 votes340 views6 answers
Alter table add foreign key mysql
SQL