CREATE TRIGGER tri_delpower_update
AFTER UPDATE ON fc_folder
FOR EACH ROW
BEGIN
IF !NEW.isshare THEN
DELETE FROM fc_folder_power WHERE link_folder = NEW.id;
END IF;
END;
请问上面的语句有什么问题
...全文
1262打赏收藏
关于mysql 创建触发器if的问题
CREATE TRIGGER tri_delpower_update AFTER UPDATE ON fc_folder FOR EACH ROW BEGIN IF !NEW.isshare THEN DELETE FROM fc_folder_power WHERE link_folder = NEW.id; END IF; END; 请问上面的语句有什么问题