So, if we’d like to create trigger, we can execute such query: CREATE TRIGGER update_value INSTEAD OF UPDATE ON persons BEGIN UPDATE persons(age) values(21) END BEGIN stmt END - is actual trigger operationįor other parts of create trigger statement please take a look at documentation.DELETE/INSERT/UPDATE ON table-name - is description on the query which will activate our trigger.BEFORE/AFTER/INSTEAD OF - is a mode of the trigger (when we’d like our operation to work - before our actual query, after or instead).trigger-name - is a name of the trigger.CREATE TRIGGER - command that says that we want to create trigger.Syntax of how to create trigger will help us to understand what we’re able to do: No, instead we can intercept some SQLite query and either do some work before it, instead of it or after it. That “operation” is not any kind of callback that we can handle and do some work. Pretty clear, but there is one caveat: this change doesn’t leave SQLite world. Triggers are database operations that are automatically performed when a specified database event occurs. If we try to speculate on the name “Trigger” we might say that probably something will be done when some changes are made to the database. But SQLite also has some advanced features and this article is about one of such called Trigger. As SQLite is very similar to SQL everyone already knows the basic concepts like querying, inserting, updating, deleting data databases and tables joining tables etc. This is because it is used on almost all mobile devices in the world.

Sqlite query android