去重IP表数据
例如通过IP地址去掉重复的数据
DELETE FROM m_ip
WHERE id NOT IN (
SELECT temp_id FROM (
SELECT MIN(id) AS temp_id
FROM m_ip
GROUP BY ip
) AS temp
);
mysql数据库中删除重复数据
未经允许不得转载：程序员中文网 » mysql数据库中删除重复数据
去重IP表数据
例如通过IP地址去掉重复的数据
DELETE FROM m_ip
WHERE id NOT IN (
SELECT temp_id FROM (
SELECT MIN(id) AS temp_id
FROM m_ip
GROUP BY ip
) AS temp
);
