mysql怎样存储二维数组

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

INSERT INTO example (data) VALUES ('[[1, 2], [3, 4]]');

SELECT JSON_EXTRACT(data, '$[0][0]') AS first_element FROM example;

$array = [[1, 2], [3, 4]];
$serialized = serialize($array);

// 存储到数据库
// ...

// 从数据库读取并反序列化
// ...
$unserialized = unserialize($row['data']);

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE array_elements (
    id INT AUTO_INCREMENT PRIMARY KEY,
    main_id INT,
    row_index INT,
    col_index INT,
    value INT,
    FOREIGN KEY (main_id) REFERENCES main_table(id)
);

INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();

INSERT INTO array_elements (main_id, row_index, col_index, value) VALUES
(@main_id, 0, 0, 1),
(@main_id, 0, 1, 2),
(@main_id, 1, 0, 3),
(@main_id, 1, 1, 4);

SELECT * FROM array_elements WHERE main_id = @main_id;