1-- clean up node table where vlan = 0 and vlan = <another number> 2-- 3-- DELETE n1.* 4-- FROM node n1 INNER JOIN 5-- (SELECT mac, switch, port from node 6-- GROUP BY mac, switch, port 7-- HAVING count(*) > 1) n2 8-- ON n1.mac = n2.mac 9-- AND n1.switch = n2.switch 10-- AND n1.port = n2.port 11-- AND n1.vlan = '0'; 12 13BEGIN; 14 15DELETE FROM node AS n1 USING (SELECT mac, switch, port from node GROUP BY mac, switch, port HAVING count(*) > 1) n2 WHERE n1.mac = n2.mac AND n1.switch = n2.switch AND n1.port = n2.port AND n1.vlan = '0'; 16 17COMMIT; 18