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 vote133 views1 answer
Mysql concatenate select results
SQL
5 votes124 views1 answer
Update sql user password
SQL
0 vote100 views1 answer
Ms sql unique
SQL
4 votes141 views2 answers
Installing sql on ubuntu
SQL
-1 vote139 views1 answer
MYSQL stored procedure select from
SQL
0 vote141 views1 answer
Alter check command
SQL
2 votes132 views1 answer
Mysql sysdate - 1 day
SQL
0 vote147 views1 answer
Get enginge db mysql
SQL
3 votes126 views4 answers
Stop MySQL
SQL
0 vote122 views1 answer
Sql comparison operators
SQL