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 vote186 views1 answer
Sql put two columns into one
SQL
103 votes310 views2 answers
Sql server LIKE '%%'
SQL
0 vote215 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote185 views1 answer
Setting default value for Boolean data type in SQL
SQL
6 votes152 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote208 views2 answers
Add colum in sql
SQL
3 votes185 views2 answers
Having in mysql
SQL
10 votes206 views2 answers
What is database
SQL
16 votes193 views1 answer
Mssql int max value
SQL
1 vote201 views1 answer
Get count by weekly pivot table sql server
SQL