SELECT customer_id, GROUP_CONCAT(product_name SEPARATOR ', ') AS product_names
FROM orders
GROUP BY customer_id;
mysql行分组用逗号隔开 亲测可试
于 2024-04-15 12:50:27 首次发布
SELECT customer_id, GROUP_CONCAT(product_name SEPARATOR ', ') AS product_names
FROM orders
GROUP BY customer_id;