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

3 votes231 views1 answer
Sql several or
SQL
0 vote190 views1 answer
Mysql regex select
SQL
0 vote209 views1 answer
Postgresql concat string with separator
SQL
1 vote203 views1 answer
Oracle compile schema
SQL
8 votes229 views2 answers
Default sql server port
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
0 vote185 views1 answer
Exit psql
SQL
44 votes300 views4 answers
Mysql alter table add column first
SQL
2 votes175 views1 answer
How to select first row of database sql
SQL
0 vote190 views1 answer
Mysql get longest string in column
SQL