例如我的表结构是这样的:
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://loyating.com
最新评论