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 VARCHAR(255)
);

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

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

CREATE TABLE example (
    id INT PRIMARY KEY
);

CREATE TABLE example_items (
    id INT PRIMARY KEY,
    example_id INT,
    value INT,
    FOREIGN KEY (example_id) REFERENCES example(id)
);

INSERT INTO example (id) VALUES (1);
INSERT INTO example_items (id, example_id, value) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3);

SELECT * FROM example_items WHERE example_id = 1;