SQLite Features/ Why to use SQLite Following is a list of features which makes SQLite popular among other lightweight databases: SQLite is…
glob
-
-
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…
-
SQLite GROUP BY Clause The SQLite GROUP BY clause is used with SELECT statement to collaborate the same identical elements into groups.…