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 vote271 views2 answers
Login to mysql
SQL
1 vote284 views1 answer
Oracle insert multiple rows into same table
SQL
1 vote280 views1 answer
Postgres set column based on another column
SQL
0 vote265 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote279 views1 answer
Tsql pad left
SQL
2 votes286 views1 answer
Flask sqlalchemy boolean field
SQL
2 votes274 views1 answer
Change primary key sql
SQL
-1 vote296 views3 answers
MySQL shutdown unexpectedly
SQL
2 votes282 views1 answer
Oracle trace file
SQL
2 votes252 views2 answers
Insert all in sql
SQL