{ Berbagi, Menulis, Dan Mengajar } Ilmu…

DELIMITER $$

USE `coba`$$

DROP TRIGGER `TriggerCopy`$$

CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `TriggerCopy` AFTER INSERT ON `tabel1`
FOR EACH ROW BEGIN

/*UPDATE tabel2
SET nama = REPLACE(New.Nama,’081′,’+6281′);*/

INSERT INTO coba.tabel2 (id,Nama,Alamat)
VALUE ( NEW.Id,NEW.Nama,NEW.Alamat);

UPDATE tabel2
SET nama = REPLACE(NEW.Nama,’081′,’+6281′);

END$$

DELIMITER ;