Guest User

Untitled

a guest
Aug 21st, 2019
99
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELIMITER ;;
  2. CREATE TRIGGER busqueda AFTER INSERT ON activas_ips FOR EACH ROW BEGIN
  3. IF NOT EXISTS(SELECT IP FROM datos_Mall activas_ips WHERE IP = New.IP)
  4. BEGIN
  5. INSERT INTO aa_cloud_avanced
  6. (Email)
  7. VALUES
  8. (New.Email);
  9. END
  10.  
  11. END
  12. ;;
  13. DELIMITER ;
RAW Paste Data