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 votes218 views4 answers
Pl sql output
SQL
0 vote192 views1 answer
Min salary in sql
SQL
0 vote203 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
8 votes222 views1 answer
Oracle search stored procedures for text
SQL
1 vote229 views1 answer
Default
SQL
5 votes232 views1 answer
Oracle get ddl
SQL
0 vote252 views1 answer
Copy from one table to another postgres using matching column
SQL
2 votes199 views1 answer
Sql server conection string
SQL
0 vote197 views4 answers
Best data type to represent money in mysql
SQL
0 vote190 views1 answer
Check if a word appears at the end sql query
SQL