select monitor_id from t_agent_connect group by agent_id HAVING count(agent_id) > 1
delete from a using t_agent_electric as a,t_agent_electric as b where a.id<b.id and a.agent_code = b.agent_code;
select monitor_id from t_agent_connect group by agent_id HAVING count(agent_id) > 1
delete from a using t_agent_electric as a,t_agent_electric as b where a.id<b.id and a.agent_code = b.agent_code;