mysql统计重复数据

为什么80%的码农都做不了架构师？>>>   

1. 表结构

CREATE TABLE `koubei_myisam2` (
	`ID` INT(11) NOT NULL AUTO_INCREMENT,
	`py_lower` VARCHAR(50) NOT NULL DEFAULT '',
	`dianming` TEXT NULL,
	`chengshi` TEXT NULL,
	`leimu` TEXT NULL,
	`dizhi` TEXT NULL,
	`dianhua` TEXT NULL,
	`shouji` TEXT NULL,
	`zhuying` TEXT NULL,
	PRIMARY KEY (`ID`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM

2. 查询字串

select py_lower, count(py_lower) from koubei_myisam2 group by py_lower having count(py_lower) > 1

结果:

转载于:https://my.oschina.net/duoli/blog/101491