mysql分组去掉重复记录_MYSQL中GROUP分组去除重复数据

GROUP分组去除重复数据

/**

* 清除同一专题中重复导入的数据

* @author tanteng

* @date 2014.07.27

*/

public function fuck_repeat(){

set_time_limit(0);

$sql = "SELECT `id` FROM `v95_special_content` GROUP BY `specialid`,`curl` HAVING COUNT(`curl`)>1 ";

$result = $this->db->query($sql);

while ($r = mysql_fetch_assoc($result)) {

$ids[] = $r['id'];

}

$ids = implode(",", $ids);

if (!$ids) {

showmessage('没有重复数据！',HTTP_REFERER);exit;

}

$sql2 = "DELETE from `v95_special_content` where `id` in($ids) ";

$this->db->query($sql2);

showmessage('执行成功，删除了'.$this->db->affected_rows().'条重复数据！',HTTP_REFERER);

}</