DELIMITER ;;
CREATE TRIGGER busqueda AFTER INSERT ON activas_ips FOR EACH ROW BEGIN
IF NOT EXISTS(SELECT IP FROM datos_Mall activas_ips WHERE IP = New.IP)
BEGIN
INSERT INTO aa_cloud_avanced
(Email)
VALUES
(New.Email);
END

END
;;
DELIMITER ;