触发器作用:删除Reader表记录后自动将Borrow表中对应的记录删去。
代码:
DROP TRIGGER Reader_delete;
CREATE TRIGGER Reader_delete
AFTER DELETE ON Reader
REFERENCING OLD AS olde
FOR EACH ROW
BEGIN
DELETE FROM Borrow WHERE ReaNo = olde.ReaNo;
END;
结果报错&#
触发器作用:删除Reader表记录后自动将Borrow表中对应的记录删去。
代码:
DROP TRIGGER Reader_delete;
CREATE TRIGGER Reader_delete
AFTER DELETE ON Reader
REFERENCING OLD AS olde
FOR EACH ROW
BEGIN
DELETE FROM Borrow WHERE ReaNo = olde.ReaNo;
END;
结果报错&#