SQLite Advantages SQLite is a very popular database which has been successfully used with on disk file format for desktop applications like…
Tag:
expressions
-
-
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:…