mysql定义字符串数组

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

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

SELECT string_array FROM example WHERE id = 1;

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

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

SELECT string_array FROM example WHERE id = 1;

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);

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 (name) VALUES ('example');
INSERT INTO string_array_table (main_id, string_value) VALUES (1, 'apple'), (1, 'banana'), (1, 'cherry');

SELECT main_table.name, string_array_table.string_value
FROM main_table
JOIN string_array_table ON main_table.id = string_array_table.main_id;