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 votes176 views2 answers
Postgresql float data type
SQL
0 vote145 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
7 votes154 views3 answers
Convert ansi sql
SQL
0 vote185 views2 answers
Insert data into multiple tables mysql
SQL
0 vote178 views1 answer
Drop domain postgresql
SQL
0 vote160 views1 answer
Manage Database in MySQL
SQL
0 vote157 views4 answers
Open mysql port bitnami tomact
SQL
1 vote144 views1 answer
Partition by sql server
SQL
0 vote138 views1 answer
Postrgres trunc
SQL
0 vote183 views1 answer
Shortcut run sql pgadmin
SQL