mysql如何保存数组

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

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

SELECT array_data FROM example WHERE id = 1;

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

$array = array("value1", "value2", "value3");
$serialized_array = serialize($array);
INSERT INTO example (array_data) VALUES ($serialized_array);

$result = mysqli_query($conn, "SELECT array_data FROM example WHERE id = 1");
$row = mysqli_fetch_assoc($result);
$array = unserialize($row['array_data']);

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

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

INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();
INSERT INTO array_elements (main_id, value) VALUES (@main_id, 'value1'), (@main_id, 'value2'), (@main_id, 'value3');

SELECT ae.value FROM array_elements ae JOIN main_table mt ON ae.main_id = mt.id WHERE mt.id = 1;