mysql 里怎么存储数组

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

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

SELECT array_data->"$[1]" AS second_element FROM example;

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

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

SELECT JSON_EXTRACT(JSON_UNQUOTE(array_data), '$[1]') AS second_element FROM example;

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE example_array (
    id INT AUTO_INCREMENT PRIMARY KEY,
    example_id INT,
    value INT,
    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, 1), (@example_id, 2), (@example_id, 3);

SELECT * FROM example_array WHERE example_id = @example_id;