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 vote284 views1 answer
Mysql milliseconds
SQL
1 vote255 views1 answer
MySQL AND Operator
SQL
0 vote317 views1 answer
Sql find gaps in date ranges
SQL
0 vote301 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote305 views1 answer
Set id count mysql
SQL
2 votes282 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
1 vote285 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote260 views1 answer
INSERT INTO table using OpenQuery
SQL
4 votes337 views4 answers
Check constraint in ms sql
SQL
7 votes299 views2 answers
MySQL IF without else
SQL