Untitled query #87212

SQL

SET @json_document = '[
    { "id": 0, "namespace": ":"},
    { "id": 1, "namespace": "Talk:"},
    { "id": 2, "namespace": "User:"},
    { "id": 3, "namespace": "User talk:"},
    { "id": 4, "namespace": "Wikipedia:"},
    { "id": 5, "namespace": "Wikipedia Talk:"},
    { "id": 6, "namespace": "File:"},
    { "id": 7, "namespace": "File talk:"},
    { "id": 8, "namespace": "MediaWiki:"}, 
    { "id": 9, "namespace": "MediaWiki talk:"}, 
    { "id": 10, "namespace": "Template:"},
    { "id": 11, "namespace": "Template talk:"},
    { "id": 12, "namespace": "Help:"},
    { "id": 13, "namespace": "Help talk:"},
    { "id": 14, "namespace": "Category:"},
    { "id": 15, "namespace": "Category talk:"}
]';

SELECT * FROM JSON_TABLE(@json_document, '$[*]'
    COLUMNS (
    id INT PATH '$.id', 
    namespace VARCHAR(50) PATH '$.namespace'
    )
) AS json_table;
SQL

Checking query status...
