例如我的表结构是这样的:
CREATE TABLE `ts_b_common_express` (
`id` smallint(1) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID',
`e_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司名称',
`e_state` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '状态',
`e_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '编号',
`f_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递鸟编号',
`e_letter` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '首字母',
`e_order` enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2' COMMENT '1常用2不常用',
`e_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司网址',
`e_zt_state` tinyint(4) DEFAULT '0' COMMENT '是否支持服务站配送0否1是',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=579 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='快递公司'
执行语法
select e_name,count(*) as count from ts_b_common_express group by e_name having count>1;
本文为张子庭博客原创文章,转载无需和我联系,但请注明来自张子庭博客博客https://www.loyating.com
最新评论