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 vote202 views1 answer
Nueva tabla mysql
SQL
1 vote209 views1 answer
Postgres convert date to string
SQL
0 vote301 views1 answer
Mysql grant access to one database
SQL
0 vote204 views1 answer
Soql user profile
SQL
1 vote209 views1 answer
Import sql file mysql commadn line
SQL
0 vote188 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote220 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote201 views1 answer
T-sql check if data exists
SQL
0 vote215 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote199 views1 answer
What is between keyword used for
SQL