Sqlite Tutorial

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…

SQLite Expressions SQLite Expressions are the combination of one or more values, operators and SQL functions. These expressions are used to evaluate…

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

SQLite Tutorial SQLite Tutorial provides basic and advanced concepts of SQLite. Our SQLite Tutorial is designed for beginners and professionals both. SQLite…

SQLite Commands SQLite commands are similar to SQL commands. There are three types of SQLite commands: DDL: Data Definition Language DML: Data…

SQLite Features/ Why to use SQLite Following is a list of features which makes SQLite popular among other lightweight databases: SQLite is…

SQLite now Function SQLite “now” is not actually a fuction, but “now” is a timestring parameter that is used in various SQLite…

SQLite COUNT Function SQLite COUNT Function is used to fetch the total count of an expression. Syntax: SELECT COUNT(aggregate_expression) FROM tables [WHERE…

SQLite Foreign Keys SQLite Foreign Key is used to specify that values in one table also appear in another table. It enforces…