MySQL 根据一个字段查询，并合并多条查询解决

一、建表语句

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `wechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

二、插入数据

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'zhangsan', '12');
INSERT INTO `user` VALUES (2, 'zhangsan', '132');
INSERT INTO `user` VALUES (3, 'zhangsan', '126');
INSERT INTO `user` VALUES (4, 'xiaoli', '156789');
INSERT INTO `user` VALUES (5, 'xiaoli', '167');

SET FOREIGN_KEY_CHECKS = 1;

三、SQL语句

SELECT a.name,GROUP_CONCAT(a.wechat SEPARATOR ',') AS wechats FROM user a GROUP BY a.name;

四、查询结果

五、总结

GROUP_CONCAT 关键字的用法。