MySQL 触发器错误

Question

如果页表中的链接更新，我想更新菜单栏表中的链接。我写了下面的代码，但没有。

CREATE TRIGGER linkdegistir AFTER UPDATE
on sayfalar
for EACH ROW
BEGIN
UPDATE menu_icerik SET menu_icerik_link=new.sayfa_sef WHERE menu_icerik_id=new.id
END

Answer 1

尝试:

CREATE TRIGGER `linkdegistir` AFTER UPDATE ON `sayfalar`
FOR EACH ROW
UPDATE `menu_icerik`
SET `menu_icerik_link` = NEW.`sayfa_sef`
WHERE `menu_icerik_id` = NEW.`id`;