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;请问上面的语句有什么问题
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;请问上面的语句有什么问题
这样写对不对?
是不是该用
NEW.isshare=1