mysql保存数组字段

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

INSERT INTO example (array_data) VALUES ('["value1", "value2", "value3"]');

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    array_data TEXT
);

INSERT INTO example (array_data) VALUES ('a:3:{i:0;s:6:"value1";i:1;s:6:"value2";i:2;s:6:"value3";}');

SELECT JSON_EXTRACT(array_data, '$[0]') AS first_value FROM example WHERE id = 1;

// 假设从数据库中获取到的数据为 $serialized_data
$array_data = unserialize($serialized_data);

UPDATE example SET array_data = JSON_SET(array_data, '$[1]', 'new_value') WHERE id = 1;

// 假设 $array_data 是从数据库中反序列化得到的数组
$array_data[1] = 'new_value';
$serialized_data = serialize($array_data);
UPDATE example SET array_data = '$serialized_data' WHERE id = 1;