如何往mysql里存放数组

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

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

SELECT data FROM example WHERE id = 1;

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

$array = array("value1", "value2", "value3");
$data = json_encode($array);
INSERT INTO example (data) VALUES ($data);

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

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE example_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    example_id INT,
    value VARCHAR(255),
    FOREIGN KEY (example_id) REFERENCES example(id)
);

INSERT INTO example () VALUES ();
SET @last_id = LAST_INSERT_ID();
INSERT INTO example_data (example_id, value) VALUES (@last_id, 'value1'), (@last_id, 'value2'), (@last_id, 'value3');

SELECT * FROM example_data WHERE example_id = 1;