Advertisement
Guest User

Trigger stops updates

a guest
Oct 28th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. CREATE DEFINER=`root`@`localhost` TRIGGER `t_ticket_after_update` AFTER UPDATE ON `t_ticket` FOR EACH ROW BEGIN
  2.     if new.tech_id != old.tech_id then
  3.         call p_c_emailnotification(1, new.id, 3);
  4.     end if;
  5.    
  6. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement