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

4 votes341 views2 answers
SELECT table_name FROM user_tables;
SQL
13 votes357 views3 answers
Sql select from multiple tables without join
SQL
-1 vote339 views1 answer
Ssql to lowercqse
SQL
0 vote404 views1 answer
Sql check if field is not null
SQL
1 vote314 views1 answer
Sql auto timestamp
SQL
0 vote334 views2 answers
Plsql function that return a table
SQL
1 vote372 views1 answer
Where not in array sql
SQL
51 votes452 views6 answers
Change column name sql
SQL
0 vote383 views1 answer
Delete a temporary table mysql
SQL
0 vote396 views1 answer
Insufficient privileges while creating view in sql oracle
SQL