mysql如何添加字符串数组

CREATE TABLE my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    string_array JSON
);

INSERT INTO my_table (string_array) VALUES ('["apple", "banana", "cherry"]');

SELECT string_array FROM my_table WHERE id = 1;

UPDATE my_table SET string_array = JSON_ARRAY_APPEND(string_array, '$', 'date') WHERE id = 1;

CREATE TABLE my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    string_array VARCHAR(255)
);

INSERT INTO my_table (string_array) VALUES ('apple,banana,cherry');

SELECT string_array FROM my_table WHERE id = 1;

UPDATE my_table SET string_array = CONCAT(string_array, ',date') WHERE id = 1;

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE string_array_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    main_id INT,
    string_value VARCHAR(255),
    FOREIGN KEY (main_id) REFERENCES main_table(id)
);

INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();
INSERT INTO string_array_table (main_id, string_value) VALUES (@main_id, 'apple'), (@main_id, 'banana'), (@main_id, 'cherry');

SELECT string_value FROM string_array_table WHERE main_id = 1;