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

5 votes256 views3 answers
Show indexes mysql
SQL
0 vote274 views2 answers
Suse Linux restart MySQL
SQL
0 vote248 views1 answer
Space not removing from column in sql
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
3 votes229 views1 answer
MySQL DELETE JOIN
SQL
5 votes248 views4 answers
Restart the psql server windows
SQL
0 vote271 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote274 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote243 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote232 views3 answers
Mysql keyword search
SQL