mysql 怎么定义数组

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

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

SELECT array_data FROM example WHERE id = 1;

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

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

SELECT array_data FROM example WHERE id = 1;

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE example_array (
    id INT AUTO_INCREMENT PRIMARY KEY,
    example_id INT,
    value VARCHAR(255),
    FOREIGN KEY (example_id) REFERENCES example(id)
);

INSERT INTO example () VALUES ();
SET @example_id = LAST_INSERT_ID();
INSERT INTO example_array (example_id, value) VALUES (@example_id, 'apple'), (@example_id, 'banana'), (@example_id, 'cherry');

SELECT ea.value FROM example_array ea JOIN example e ON ea.example_id = e.id WHERE e.id = 1;