mysql数组存入

INSERT INTO table_name (array_column) VALUES ('value1,value2,value3');

INSERT INTO table_name (json_column) VALUES ('["value1", "value2", "value3"]');

SELECT REPLACE(array_column, ',', ', ') AS array_values FROM table_name;

SELECT JSON_EXTRACT(json_column, '$') AS array_values FROM table_name;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE roles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    role_name VARCHAR(255) NOT NULL
);

CREATE TABLE user_roles (
    user_id INT,
    role_id INT,
    PRIMARY KEY (user_id, role_id),
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (role_id) REFERENCES roles(id)
);

INSERT INTO users (name) VALUES ('Alice');
INSERT INTO roles (role_name) VALUES ('admin'), ('user');
INSERT INTO user_roles (user_id, role_id) VALUES (1, 1), (1, 2);

SELECT u.name, GROUP_CONCAT(r.role_name) AS roles
FROM users u
JOIN user_roles ur ON u.id = ur.user_id
JOIN roles r ON ur.role_id = r.id
GROUP BY u.id;