advance sqlite

SQLite Advantages SQLite is a very popular database which has been successfully used with on disk file format for desktop applications like…

SQLite Julianday Function The SQLite julianday function facilitates you to apply modifiers and then returns the date as a Julian Day after…

SQLite Trigger AFTER DELETE It specifies how to create trigger after delete the data. We have two tables COMPANY and AUDIT. COMPANY…

SQLite Aggregate Function SQLite Aggregate functions are the functions where values of multiple rows are grouped together as input on certain criteria…

SQLite Drop Table In SQLite, DROP TABLE statement is used to remove a table definition and all associated data, indexes, triggers, constraints…

SQLite LIKE Clause (Operator) The SQLite LIKE operator is used to match text values against a pattern using wildcards. In the case…

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:…