SQLite 中的级联触发器

SQLite 中的级联触发器：强大的数据库操作工具

sql
CREATE TRIGGER trigger_name 
AFTER INSERT OR UPDATE OR DELETE ON table_name
BEGIN
    -- 触发器的执行逻辑
END;

sql
-- 创建 Authors 表
CREATE TABLE Authors (
    author_id INTEGER PRIMARY KEY,
    author_name TEXT
);
-- 创建 Books 表
CREATE TABLE Books (
    book_id INTEGER PRIMARY KEY,
    book_title TEXT,
    author_id INTEGER,
    FOREIGN KEY (author_id) REFERENCES Authors(author_id) ON DELETE CASCADE
);
-- 创建级联触发器
CREATE TRIGGER delete_author_trigger
AFTER DELETE ON Authors
FOR EACH ROW
BEGIN
    DELETE FROM Books WHERE author_id = OLD.author_id;
END;