CREATE TEMPORARY TABLE `ZipTemp` (
`ZipCode` CHAR(6) DEFAULT NULL,
PRIMARY KEY (`ZipCode`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;
INSERT INTO ZipTemp (ZipCode)
SELECT DISTINCT ZipCode
FROM AreaTownZip a
WHERE a.ZipLat BETWEEN 42.0986885071 AND 44.0986885071
AND a.ZipLong BETWEEN -80.0210678101 AND -78.0210678101;
in Niagara Falls, NY