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 vote293 views1 answer
Sql get table last modified time
SQL
0 vote287 views1 answer
Postgres float to int
SQL
2 votes371 views3 answers
Mysql unix timestamp to date
SQL
0 vote310 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
28 votes312 views6 answers
Mysql change user password
SQL
0 vote284 views1 answer
Get first name and last name from full name string in SQL
SQL
17 votes291 views5 answers
Order by sql
SQL
1 vote344 views1 answer
Create new table from old table
SQL
11 votes313 views2 answers
Insert date sql
SQL
0 vote333 views3 answers
Call to undefined function mysql_connect()
SQL