Guest User

Untitled

a guest
Aug 24th, 2018
406
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. Using an update trigger to update another table
  2. DELIMITER $$
  3. DROP TRIGGER IF EXISTS after_update_A;
  4.  
  5. CREATE TRIGGER `after_update_A`
  6.  
  7. AFTER UPDATE ON `A` FOR EACH ROW
  8. BEGIN
  9. UPDATE TABLE B
  10. SET username = NEW.username
  11. , password = NEW.password
  12. , email = NEW.email
  13. WHERE id = NEW.id
  14. END
  15.  
  16. $$
  17. DELIMITER ;
  18.  
  19. CREATE TRIGGER `after_update_A` AFTER UPDATE ON `A` FOR EACH ROW
  20. BEGIN
  21. UPDATE TABLE B
  22. SET username = NEW.username
  23. , password = NEW.password
  24. , email = NEW.email
  25. WHERE id = NEW.id; //<<-----------
  26. END $$
Add Comment
Please, Sign In to add comment