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 vote381 views1 answer
Select new table sql
SQL
0 vote331 views1 answer
Tsql table column constraint must be uppercase
SQL
10 votes318 views3 answers
Sql check double value
SQL
0 vote346 views1 answer
Python mysql show databases
SQL
1 vote331 views1 answer
Update mysql centos
SQL
0 vote325 views1 answer
Psql list rules
SQL
1 vote316 views1 answer
Postgresql blocked on mac
SQL
25 votes343 views6 answers
How to change column name in mysql
SQL
0 vote309 views1 answer
Mysql grant user wildcard database
SQL
3 votes302 views3 answers
Stop mysql service ubuntu
SQL