Примеры триггеров MySQL

DROP TRIGGER IF EXISTS `update_sms_plus`; CREATE TRIGGER `update_sms_plus` AFTER UPDATE ON `sms_plus` FOR EACH ROW UPDATE sms_plus SET city = NEW.gorod WHERE id=NEW.id;