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

7 votes131 views1 answer
Buy forge mods server hosting
SQL
0 vote129 views1 answer
Postgresql using reserved word as column name
SQL
5 votes138 views1 answer
Oracle create table comment
SQL
0 vote83 views1 answer
Bigquery information_schema schema all columns
SQL
3 votes138 views1 answer
Where id is in list sql
SQL
0 vote211 views1 answer
Python mysql check if database exists
SQL
0 vote134 views1 answer
Oracle query to find schema you are working on
SQL
0 vote124 views1 answer
MySQL FIND_IN_SET()
SQL
20 votes137 views6 answers
Mysql reset auto increment
SQL
0 vote137 views2 answers
Athena drop partition
SQL