Small. Fast. Reliable.
Choose any three.

创建触发stmt

CREATE TEMP TEMPORARY TRIGGER IF NOT EXISTS schema-name . trigger-name BEFORE AFTER INSTEAD OF DELETE INSERT UPDATE OF column-name , ON table-name FOR EACH ROW WHEN expr BEGIN update-stmt ; END insert-stmt delete-stmt select-stmt

用法 ：   sql-stmt

参考：   delete-stmt    expr    insert-stmt    select-stmt    update-stmt

另请参见：   lang_createtrigger.html