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 vote104 views1 answer
Oracle sql copy table without data
SQL
1 vote122 views3 answers
Connection string mysql
SQL
3 votes126 views3 answers
List columns in table postgres
SQL
0 vote138 views2 answers
Mysql show foreign keys
SQL
2 votes110 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote103 views1 answer
Update and keep original value sql
SQL
1 vote99 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote111 views1 answer
Mysql view curren querys
SQL
0 vote103 views1 answer
Find invalid datetime field
SQL
8 votes103 views2 answers
Mysql grant all privileges to user from any host
SQL