Guest User

Untitled

a guest
May 26th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. DELIMITER |
  2. CREATE TRIGGER version_change BEFORE UPDATE ON documents
  3. FOR EACH ROW
  4. BEGIN
  5. DECLARE changeDescription varchar(255) default null;
  6. DECLARE changeName varchar(255) default null;
  7.  
  8.  
  9. IF new.description != old.description THEN
  10. SET changeDescription = 'Hubo un cambio la Descripcion';
  11. END IF;
  12.  
  13. IF new.name != old.name THEN
  14. SET changeName = 'Hubo un cambio el Name';
  15. END IF;
  16.  
  17. insert into versions (changes) values(CONCAT(changeDescription, changeName));
  18.  
  19. END;
  20. |
  21. DELIMITER ;
Add Comment
Please, Sign In to add comment