mysql统计重复的属性字段有哪些

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(22) NULL DEFAULT NULL,
  `dept` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `education` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `competent` varchar(223) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('bf3a3c5b-bf12-4d82-9ac3-1297202da3e8', '李诗诗', 25, '财务部', '研究生', '技术专家');
INSERT INTO `user` VALUES ('\r\n\r\n\r\n26c9aff0-49f1-42b2-9d69-ab3e8b77abb1', '宋圆圆', 25, '人事部', '本科', '经理');
INSERT INTO `user` VALUES ('76918c8c-f770-48f9-bd41-9a0050ff89c5', '柳如是', 25, '技术部', '研究生', '高级工程师');
INSERT INTO `user` VALUES ('b33292fe-191d-48f6-9b04-60806321b90c', '李香君', 25, '信息部', '研究生', '高级工程师');
INSERT INTO `user` VALUES ('ab01d7a9-3f3d-4587-8bae-1bc31ef77082', '董小宛', 25, '财务部', '研究生', '技术专家');
INSERT INTO `user` VALUES ('bf3a3c5b-bf12-4d82-9ac3-1297202da3ew', '苏小小', 25, '人事部', '本科', '中级工程师');

SET FOREIGN_KEY_CHECKS = 1;

统计用户id哪些有重复的

 

select id from user GROUP BY id having count(id) >1

 统计出来没有重复的

 执行，就是刚才添加的重复的id: