{ Berbagi, Menulis, Dan Mengajar } Ilmu…

DELIMITER $$

USE `sms2`$$

DROP TRIGGER /*!50032 IF EXISTS */ `CopyPbk`$$

CREATE
/*!50017 DEFINER = ‘dimas’@’%’ */
TRIGGER `CopyPbk` AFTER INSERT ON `pbk`
FOR EACH ROW BEGIN
INSERT INTO sms2.pbk_copy (GroupID,NAME,SenderNumber,DestinationNumber,id_pbk)
VALUE ( NEW.GroupID,NEW.NAME,NEW.Number,NEW.Number,NEW.id_pbk);
END;
$$

DELIMITER ;