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 vote224 views1 answer
Mysql faster insert
SQL
0 vote180 views1 answer
Remove binlog mysql
SQL
0 vote214 views1 answer
Mysql show create db
SQL
0 vote226 views1 answer
Psql create usr
SQL
2 votes237 views1 answer
Orcale index size
SQL
4 votes195 views1 answer
Wilayah indonesia sql
SQL
0 vote187 views1 answer
Update top 100 sql
SQL
1 vote148 views1 answer
Enable mysql slow query log
SQL
0 vote254 views1 answer
Inner join distinct
SQL
7 votes196 views4 answers
Index in mysql
SQL