Question

php mysql 查询单个字段重复的行

现在有表 XLS 表 DXLS
两个表字段相同：ID，IP。
XLS表有数据，DXLS表内没数据。
现在我要将XLS表内IP字段不重复的行插入进DXLS表，或者直接删除XLS表内IP字段重复的行。
求大神帮忙

Answer 1

试试：
INSERT INTO `DXLS` (SELECT * FROM `XLS` GROUP BY `IP`)

Answer 2

mysql_query("INSERT INTO DXLS (IP, ID) VALUES (SELECT DISTINCT(IP), ID FROM XLS)") or die(mysql_error());

Answer 3

delete from XLS where ID in (select ID from (select max(ID) as ID,count(IP) as count from XLS group by IP having count >1 order by count desc) as tab )

用这样的mysql语句就ok了

Answer 4

INSERT INTO `DXLS` (SELECT * FROM `XLS` group by `IP` order by ID asc) ;

参考资料http://www.2cto.com/database/201202/120259.html

Answer 5

正在学习正在学习 。