mysql可以保存数组

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

INSERT INTO example (data) VALUES ('["apple", "banana", "cherry"]');

SELECT data->>"$.1" AS fruit FROM example;

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE array_elements (
    id INT AUTO_INCREMENT PRIMARY KEY,
    main_id INT,
    element VARCHAR(255),
    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, element) VALUES (@main_id, 'apple'), (@main_id, 'banana'), (@main_id, 'cherry');

SELECT element FROM array_elements WHERE main_id = @main_id;