mysql如何添加数组信息

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

INSERT INTO example (array_data) VALUES ('[1, 2, 3, 4, 5]');

SELECT array_data FROM example WHERE id = 1;

UPDATE example SET array_data = JSON_ARRAY_APPEND(array_data, '$', 6) WHERE id = 1;

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

INSERT INTO example (array_data) VALUES ('[1, 2, 3, 4, 5]');

SELECT array_data FROM example WHERE id = 1;

CREATE TABLE main_table (
    id INT AUTO_INCREMENT PRIMARY KEY
);

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

INSERT INTO main_table () VALUES ();
SET @main_id = LAST_INSERT_ID();
INSERT INTO array_table (main_id, value) VALUES (@main_id, 1), (@main_id, 2), (@main_id, 3);

SELECT * FROM array_table WHERE main_id = 1;