mysql数据添加字符串数组

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

-- 插入数据
INSERT INTO example (tags) VALUES ('["tag1", "tag2", "tag3"]');

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

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

-- 插入数据
INSERT INTO example (tags) VALUES ('["tag1", "tag2", "tag3"]');

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

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

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

-- 插入数据
INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();
INSERT INTO tag_table (main_id, tag) VALUES (@main_id, 'tag1'), (@main_id, 'tag2'), (@main_id, 'tag3');

-- 查询数据
SELECT t1.id, t2.tag
FROM main_table t1
JOIN tag_table t2 ON t1.id = t2.main_id
WHERE t1.id = 1;