Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER `toUpdateItem_trig` AFTER UPDATE ON `tbl_item`
- FOR EACH ROW begin
- IF ((SELECT count(1) FROM `tbl_man` WHERE tbl_man.name = NEW.par_name) = 0)
- THEN
- INSERT INTO `tbl_man`(`name`, `ctr`, `city`, `addr`, `tel`, `del`) VALUES (NEW.par_name,'-','-','-','-','0');
- ELSE UPDATE `tbl_man` SET `del`='0' where `name` LIKE old.par_name;
- END IF;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement