clauses

SQLite Trigger: AFTER INSERT/ BEFORE INSERT It specifies how to create trigger after insert the data. Suppose, we have two tables COMPANY…

SQLite AND Operator The SQLite AND Operator is generally used with SELECT, UPDATE and DELETE statement to combine multiple conditions. It is…

SQLite DROP TRIGGER In SQLite, DROP TRIGGER command is used to drop/ delete trigger from a table. Syntax: DROP TRIGGER trigger_name; Example:…

SQLite LIMIT Clause The SQLite LIMIT clause is used to limit the data amount fetched by SELECT command from a table. Syntax:…

SQLite Trigger: AFTER UPDATE It specifies how to create trigger after update the data. Suppose, we have two tables COMPANY and AUDIT,…

SQLite Attach Database What is Attach database? Assume a condition where you have multiple databases available and you have to use only…

SQLite Export SQLite facilitates you to export data from SQLite database to CSV file. You can export the whole table or less…

SQLite MAX Function SQLite MAX function is used to fetch the maximum value of an expression. Syntax: SELECT MAX(aggregate_expression) FROM tables [WHERE…

SQLite Triggers SQLite Trigger is an event-driven action or database callback function which is invoked automatically when an INSERT, UPDATE, and DELETE…

SQLite AVG function SQLite AVG function is used to retrieve the average value of an expression. Syntax: SELECT AVG(aggregate_expression) FROM tables [WHERE…