SQLite datetime Function The SQLite datetime function is used to retrieve date and time in different format. The result format of datetime…
Category:
Sqlite Tutorial
-
-
SQLite Insert Query In SQLite, INSERT INTO statement is used to add new rows of data into a table. After creating the…
-
Connect SQLite with PHP For Connecting SQLite database with PHP, you must have PHP and SQLite installed on your system. If sqlite…
-
SQLite DELETE Query In SQLite, DELETE query is used to delete the existing records from a table. You can use it with…
-
SQLite Installation SQLite is known for its zero configuration which means no complex setup or administration is required. Let’s see how to…
-
SQLite Syntax Syntax is a unique set of rules and guidelines. Following is a list of syntax for SQLite. Case sensitivity: SQLite…
-
SQL vs SQLite Differences between SQL and SQLite SQL SQLite SQL is a Structured Query Language used to query a Relational Database…
-
SQLite Detach Database The SQLite DETACH DATABASE statement is used to detach the alias-named database from a database connection which was previously…
-
SQLite Joins In SQLite, JOIN clause is used to combine records from two or more tables in a database. It unites fields…
-
SQLite time Function SQLite time function is used to calculate time and return time in ‘HH-MM-SS’ format. Syntax: time(timestring, [ modifier1, modifier2,…