INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('14570', 'Dilardmtcy, GA, USA', '23317') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50295', 'MTC - GSM Services', '22583') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50296', 'MTC - Voicemail', '22583') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('22583', 'MTC GSM Network', '50404') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('14200', 'Mtcharlstn, NV, USA', '23316') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50006', 'MTN GSM', '50401') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50419', 'MTN GSM (27603)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50418', 'MTN GSM (27604)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50420', 'MTN GSM (27605)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50957', 'MTN GSM (27630)', NULL) ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50958', 'MTN GSM (27630)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50959', 'MTN GSM (27631)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50960', 'MTN GSM (27632)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50300', 'MTN GSM (2771)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50442', 'MTN GSM (27710)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50298', 'MTN GSM (27719)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('22669', 'MTN GSM (2773)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('24758', 'MTN GSM (2775)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('24761', 'MTN GSM (2777)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50074', 'MTN GSM (2777)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('24762', 'MTN GSM (2778)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50425', 'MTN GSM (27810)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('24756', 'MTN GSM (2783)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('24763', 'MTN GSM (2785)', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50086', 'MTN GSM Voicemail', '50006') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('22582', 'Namibia', '51139') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('33257', 'Namibia (264)', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23250', 'Namibia - WRONG!', NULL) ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50404', 'Namibia GSM', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50405', 'Namibia GSM (delete)', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23541', 'Namibia Katima Mulilo', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23538', 'Namibia Oranjemund', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23540', 'Namibia Oshakati', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23542', 'Namibia Tsumeb', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23539', 'Namibia Walvis Bay', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23536', 'Namibia Windhoek', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('23537', 'Namibia Windhoek, Airport', '22582') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50335', 'Telkom Mobile', '50401') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50443', 'Telkom Mobile (27614)', '50335') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50647', 'Telkom Mobile (2781)', '50335') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50598', 'Telkom Mobile - Closed User Group', '50335') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50292', 'TN Mobile - GSM Services', '50291') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50293', 'TN Mobile - Voicemail', '50291') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); INSERT INTO `locations` (location_id, location, parent_loc_id) VALUES ('50291', 'TN Mobile GSM Network', '50404') ON DUPLICATE KEY UPDATE location = VALUES(location), parent_loc_id = VALUES(parent_loc_id); Completed import into "locations"