Skip to content
created by Aha00aAha00a at 2015-04-27
last modified by Aha00aAha00a at 2022-01-18
revision: 4

MySQL Range

1. 0 to 1023

1.1. ver 8.0 or higher

WITH
    RECURSIVE num(n) AS (
        SELECT 1
        UNION ALL
        SELECT n + 1 FROM num WHERE n < 1024
    )
    SELECT * from num;

--2022-01-18

1.2. under ver 8.0

SELECT
    T1.SEQ +
    T2.SEQ +
    T3.SEQ +
    T4.SEQ +
    T5.SEQ +
    T6.SEQ +
    T7.SEQ +
    T8.SEQ +
    T9.SEQ +
    T10.SEQ +
    0 SEQ
    FROM (SELECT 0 SEQ UNION ALL SELECT 1) T1
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 2) T2
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 4) T3
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 8) T4
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 16) T5
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 32) T6
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 64) T7
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 128) T8
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 256) T9
    CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 512) T10

--2015-04-27

2. 2019-01-01 to 2021-10-20 (+1023) by day

SELECT
    SEQ,
    DATE_ADD(STR_TO_DATE('2019-01-01', '%Y-%m-%d'), INTERVAL SEQ DAY) date
    FROM (
        SELECT
            T1.SEQ +
            T2.SEQ +
            T3.SEQ +
            T4.SEQ +
            T5.SEQ +
            T6.SEQ +
            T7.SEQ +
            T8.SEQ +
            T9.SEQ +
            T10.SEQ +
            0 SEQ
            FROM (SELECT 0 SEQ UNION ALL SELECT 1) T1
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 2) T2
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 4) T3
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 8) T4
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 16) T5
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 32) T6
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 64) T7
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 128) T8
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 256) T9
            CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 512) T10
    ) Z

--2019-01-25

3. See Also

3.2. Similar Pages

Similar pages by cosine similarity. Words after page name are term frequency.

3.3. Adjacent Pages

Control
≤ 32
all
1.0x
1.0x
80
-120
ON
Metrics
Nodes(visible/total)0/0
Links(visible/total)0/0
Avg degree0.00
Depth coverage0
Queue(fetch/graph)0 / 0
Zoom(scale)1.00x
Ctrl/⌘ + Scroll: Zoom
Root 1-hop 2-hop+