mysql存数组什么类型

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

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

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

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

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

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

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    product VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (name) VALUES ('Alice');
INSERT INTO orders (user_id, product) VALUES (1, 'Apple'), (1, 'Banana');