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

1 vote215 views1 answer
Get all db sizes in mysql server
SQL
1 vote225 views1 answer
Mysql search like order by best match
SQL
1 vote209 views1 answer
Sql trigger before delete
SQL
4 votes217 views3 answers
Oracle sql first day of quarter
SQL
0 vote226 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
1 vote242 views2 answers
Postgresql check privileges on schema
SQL
0 vote211 views1 answer
Why mysql is used?
SQL
7 votes225 views2 answers
Sql empty table
SQL
13 votes202 views2 answers
Display users in mysql
SQL
0 vote210 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL