mysql读取二维数组

CREATE TABLE matrix (
    id INT PRIMARY KEY,
    row INT,
    col INT,
    value INT
);

INSERT INTO matrix (id, row, col, value) VALUES
(1, 0, 0, 1),
(2, 0, 1, 2),
(3, 1, 0, 3),
(4, 1, 1, 4);

SELECT * FROM matrix ORDER BY row, col;

CREATE TABLE matrix_json (
    id INT PRIMARY KEY,
    data JSON
);

INSERT INTO matrix_json (id, data) VALUES
(1, '[["1", "2"], ["3", "4"]]');

SELECT JSON_EXTRACT(data, '$[0]') AS row1, JSON_EXTRACT(data, '$[1]') AS row2 FROM matrix_json WHERE id = 1;

INSERT INTO matrix (id, row, col, value) VALUES
(1, 0, 0, '1'); -- 错误，value应该是INT类型

INSERT INTO matrix (id, row, col, value) VALUES
(1, 0, 0, 1); -- 正确

INSERT INTO matrix_json (id, data) VALUES
(1, '[["1", "2"], ["3", "4"')); -- 错误，JSON字符串格式不正确

INSERT INTO matrix_json (id, data) VALUES
(1, '[["1", "2"], ["3", "4"]]'); -- 正确