mysql数据库存放数组

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

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

SELECT data->"$[0]" AS first_element FROM example WHERE id = 1;

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

INSERT INTO example (id, data) VALUES (1, 'a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;}');

SELECT unserialize(data) AS array_data FROM example WHERE id = 1;

CREATE TABLE main_table (
    id INT PRIMARY KEY
);

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

INSERT INTO main_table (id) VALUES (1);
INSERT INTO array_elements (id, main_id, value) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3);

SELECT * FROM array_elements WHERE main_id = 1;