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 TEXT
);

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

-- 查询数据
SELECT unserialize(data) AS fruits FROM example;

-- 创建主表
CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

-- 创建关联表
CREATE TABLE related_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    main_id INT,
    value VARCHAR(255),
    FOREIGN KEY (main_id) REFERENCES main_table(id)
);

-- 插入数据
INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();
INSERT INTO related_table (main_id, value) VALUES (@main_id, 'apple'), (@main_id, 'banana'), (@main_id, 'cherry');

-- 查询数据
SELECT value FROM related_table WHERE main_id = @main_id;