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 vote103 views1 answer
Import csv to mysql
SQL
0 vote146 views1 answer
Plpgsql if statement
SQL
0 vote154 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
5 votes137 views1 answer
Oracle find foreign key dependencies
SQL
24 votes165 views4 answers
Delete db postgres
SQL
0 vote156 views2 answers
Reseed sql identity
SQL
5 votes158 views3 answers
Select tables from mysql database
SQL
0 vote101 views1 answer
Mysql select top 2
SQL
0 vote154 views1 answer
Sql server union if table exist
SQL
0 vote96 views1 answer
Mysql date + 1 day
SQL