mysql中可以存数组吗

-- 创建表
CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data JSON
);

-- 插入数据
INSERT INTO example (data) VALUES ('["apple", "banana", "cherry"]');

-- 查询数据
SELECT data FROM example;

-- 创建表
CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data VARCHAR(255)
);

-- 插入数据
INSERT INTO example (data) VALUES ('apple,banana,cherry');

-- 查询数据
SELECT data FROM example;

-- 创建主表
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 e.id, ei.item FROM example e JOIN example_items ei ON e.id = ei.example_id;

SELECT data->'$.0' AS first_item FROM example;

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

SELECT SUBSTRING_INDEX(data, ',', 1) AS first_item FROM example;
UPDATE example SET data = CONCAT(SUBSTRING_INDEX(data, ',', 1), ',grape,', SUBSTRING(data, LENGTH(SUBSTRING_INDEX(data, ',', 1)) + 2)) WHERE id = 1;