mysql数据库可以存数组不

CREATE TABLE example (
  id INT PRIMARY KEY,
  array_str VARCHAR(255)
);

INSERT INTO example (id, array_str) VALUES (1, '1,2,3');

SELECT array_str FROM example WHERE id = 1; -- 获取存储的数组字符串

-- 将字符串转换为数组
SELECT SUBSTRING_INDEX(array_str, ',', 1) AS element1,
       SUBSTRING_INDEX(SUBSTRING_INDEX(array_str, ',', 2), ',', -1) AS element2,
       SUBSTRING_INDEX(SUBSTRING_INDEX(array_str, ',', 3), ',', -1) AS element3
FROM example WHERE id = 1;

-- 添加元素到数组
UPDATE example SET array_str = CONCAT(array_str, ',4') WHERE id = 1;

-- 删除数组元素
UPDATE example SET array_str = REPLACE(array_str, '2,', '') WHERE id = 1;

CREATE TABLE example (
  id INT PRIMARY KEY,
  array_json JSON
);

INSERT INTO example (id, array_json) VALUES (1, '[1, 2, 3]');

SELECT array_json FROM example WHERE id = 1; -- 获取存储的JSON数组

-- 将JSON数组转换为结果集
SELECT JSON_EXTRACT(array_json, '$[0]') AS element1,
       JSON_EXTRACT(array_json, '$[1]') AS element2,
       JSON_EXTRACT(array_json, '$[2]') AS element3
FROM example WHERE id = 1;

-- 添加元素到JSON数组
UPDATE example SET array_json = JSON_ARRAY_APPEND(array_json, '$', 4) WHERE id = 1;

-- 删除JSON数组元素
UPDATE example SET array_json = JSON_REMOVE(array_json, '$[1]') WHERE id = 1;