SQLite | Trigger
If you create a trigger, another SQL statement can be executed automatically when data is added to or modified in a table. For example, when a column value in one table is modified, it is possible to automatically modify a column value in another table to the same value. This section explains how to create triggers.