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 vote162 views2 answers
Sql last updated
SQL
3 votes174 views1 answer
Locate sql server
SQL
0 vote174 views1 answer
Psql list view rules
SQL
0 vote226 views1 answer
What is metadata in sql
SQL
0 vote171 views2 answers
Plsql regex match whole word
SQL
2 votes170 views1 answer
How to find constraints on a table in oracle
SQL
0 vote165 views1 answer
Soql last week
SQL
0 vote175 views1 answer
Create date sql
SQL
9 votes184 views3 answers
Mysql show table column full description
SQL
1 vote174 views2 answers
Maximum number of tables in mysql
SQL