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 vote211 views1 answer
Sql server on mac m1
SQL
1 vote187 views1 answer
Can not connect to mysql server
SQL
0 vote158 views1 answer
Oracle sysdba connect as another user
SQL
1 vote200 views1 answer
How to get the date diff on once field in sql server
SQL
11 votes210 views2 answers
How to import mysql database command line
SQL
0 vote181 views1 answer
List MySQL Table and Index Size
SQL
0 vote211 views1 answer
Populate db from command line postgres
SQL
1 vote185 views1 answer
Delete triger pl pg sql
SQL
0 vote186 views1 answer
Get week day name sql server
SQL
1 vote264 views1 answer
How to show index type in postgresql
SQL