MySQL Trigger Update

DELIMITER $$ USE `soatserv_korattsc`$$ DROP TRIGGER /*!50032 IF EXISTS */ `member_detail_update`$$ CREATE /*!50017 DEFINER = 'soatserv_korat'@'%' */ TRIGGER `member_detail_update` AFTER UPDATE ON `sm_mem_m_membership_registered` FOR EACH ROW BEGIN UPDATE sc_confirm_register SET MEMBER_NAME = NEW.MEMBER_NAME , MEMBER_SURNAME = NEW.MEMBER_SURNAME WHERE MEMBERSHIP_NO = NEW.MEMBERSHIP_NO; END; $$ DELIMITER ;

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.