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结果:
