[FONT="Courier New"]DELIMITER $$

USE `databaseName`$$

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

CREATE

 /*!50017 DEFINER = 'root'@'localhost' */

 TRIGGER `triggerName` AFTER INSERT ON `tableB` 

 FOR EACH ROW BEGIN 

 DECLARE done INT DEFAULT FALSE;

 DECLARE ids INT;

 DECLARE cur CURSOR FOR 

 SELECT `tableC` FROM `COLUMNS` WHERE `COLUMN` = NEW.`id`;

 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

 OPEN cur;

 ins_loop: LOOP

 FETCH cur INTO ids;

 IF done THEN

 LEAVE ins_loop;

 END IF; 

 INSERT INTO `tableA`(`id`, `COLUMN`) VALUES (ids, NEW.`id`);

 END LOOP;

 CLOSE cur; 

 END;

$$

DELIMITER ;[/FONT]

skript di atas hanya contoh simple n global ja gan... bisa agan2 sesuaikan dengan kasus agan sendiri2....