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 votes154 views2 answers
Postgres concat
SQL
0 vote155 views1 answer
On delete set default
SQL
0 vote170 views1 answer
Suhaib
SQL
0 vote144 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote135 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
1 vote137 views1 answer
Psql connections
SQL
2 votes136 views1 answer
Set username and password for postgresql database
SQL
3 votes131 views2 answers
Oracle sql truncate table
SQL
0 vote153 views1 answer
Sql server insert inner join
SQL
1 vote171 views1 answer
How to get alternate records from a table in sql
SQL