Sqlite Tutorial

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…

SQLite Operators SQLite operators are reserved words or characters used in SQLite statements when we use WHERE clause to perform operations like…

SQLite Create Database In SQLite, the sqlite3 command is used to create a new database. Syntax: sqlite3 DatabaseName.db Your database name should…

SQLite GLOB Clause (Operator) The SQLite GLOB operator matches only text values against a pattern by using wildcards. When the search expression…

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

SQLite Create Table In SQLite, CREATE TABLE statement is used to create a new table. While creating the table, we name that…