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 example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data VARCHAR(255)
);

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

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(data, ',', n), ',', -1) AS fruit
FROM example, (SELECT 1 n UNION ALL SELECT 2 UNION ALL SELECT 3) numbers
WHERE n <= LENGTH(data) - LENGTH(REPLACE(data, ',', '')) + 1;

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY
);

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

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

SELECT item FROM example_items WHERE example_id = @example_id;

SELECT JSON_EXTRACT(data, '$[1]') AS fruit FROM example;

UPDATE example SET data = JSON_SET(data, '$[1]', 'orange') WHERE id = 1;