去重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
);
去重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
);