mysql 保存数组

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

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

-- 查询数据
SELECT array_data FROM example WHERE id = 1;

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

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

-- 插入数据
INSERT INTO main_table (name) VALUES ('example');
SET @main_id = LAST_INSERT_ID();
INSERT INTO array_elements (main_id, element) VALUES (@main_id, 'apple'), (@main_id, 'banana'), (@main_id, 'orange');

-- 查询数据
SELECT element FROM array_elements WHERE main_id = 1;