mysql行合并成一行

CREATE TABLE orders (
    order_id INT,
    customer_name VARCHAR(100),
    product_name VARCHAR(100),
    quantity INT
);

SELECT 
    customer_name,
    GROUP_CONCAT(product_name ORDER BY order_id SEPARATOR ', ') AS products,
    SUM(quantity) AS total_quantity
FROM 
    orders
GROUP BY 
    customer_name;

SET SESSION group_concat_max_len = 1000000;

CREATE TABLE orders (
    order_id INT,
    customer_name VARCHAR(100),
    product_name VARCHAR(100),
    quantity INT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci GROUP_CONCAT_MAX_LEN=1000000;

SELECT 
    customer_name,
    JSON_ARRAYAGG(JSON_QUOTE(product_name)) ORDER BY order_id AS products,
    SUM(quantity) AS total_quantity
FROM 
    orders
GROUP BY 
    customer_name;