-
SQLite Tutorial
- sqlite-tutorial
- sql-vs-sqlite
- sqlite-history
- sqlite-features
- sqlite-advantages
- sqlite-installation
- sqlite-commands
- sqlite-syntax
- sqlite-data-types
- sqlite-operators
- sqlite-expressions
Databases
Table
CRUD Operation
Clauses/Conditions
- sqlite-where
- sqlite-and
- sqlite-or
- sqlite-like
- sqlite-glob
- sqlite-limit
- sqlite-order-by
- sqlite-group-by
- sqlite-having
- sqlite-distinct
- sqlite-union
- sqlite-union-all
SQLite Joins
SQLite Date & Time
- sqlite-date-and-time
- sqlite-date()
- sqlite-datetime()
- sqlite-juliandday()
- sqlite-now()
- sqlite-strftime()
- sqlite-time()
Aggregate Functions
SQLite Triggers
SQLite Keys
SQLite Import/Export
Connectivity
Interview Questions
SQLite Trigger: AFTER UPDATEIt specifies how to create trigger after update the data. Suppose, we have two tables COMPANY and AUDIT, here we want to keep audit trial for every record being updated in COMPANY table. COMPANY table: Create a new table named AUDIT where log messages will be inserted whenever there is an updation in COMPANY table. AUDIT table: CREATE trigger after update: Use the following syntax to create a trigger named "after_up" on COMPANY table after update operation.  Now update the old record as following:  See the result:  See the trigger: 
SQLite Trigger: BEFORE UPDATEIf you want to create the trigger before updating the data:  See the triggers: 
Next TopicSQLite Trigger After Delete
|