Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. CREATE TRIGGER `toUpdateItem_trig` AFTER UPDATE ON `tbl_item`
  2.  FOR EACH ROW begin
  3.        IF ((SELECT count(1) FROM `tbl_man` WHERE tbl_man.name = NEW.par_name) = 0)
  4.        THEN
  5.            INSERT INTO `tbl_man`(`name`, `ctr`, `city`, `addr`, `tel`, `del`) VALUES (NEW.par_name,'-','-','-','-','0');
  6.        ELSE UPDATE `tbl_man` SET `del`='0' where `name` LIKE old.par_name;
  7.        END IF;
  8.        
  9. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement