SQLite History SQLite was designed originally on August 2000. It is named SQLite because it is very light weight (less than 500Kb…
glob
-
-
SQLite Primary Keys SQLite primary key is a simple field or a combination of fields which is used to uniquely define a…
-
Date and Time() Functions In SQLite, date and time() functions are used to retrieve current date and time. The date and time…
-
SQLite Import You can import a CSV file into SQLite table by using sqlite3 tool and .import command. This command accepts a…
-
SQLite SELECT Query In SQLite database, SELECT statement is used to fetch data from a table. When we create a table and…
-
Java with SQLite To use SQLite with java programs, you must have SQLite JDBC Driver and Java set up on the system.…
-
SQLite Date Function The SQLite “DATE” function is used to retrieve the date and return it in ‘YYYY-MM-DD’ format. Syntax: date(timestring, […
-
SQLite Inner Join The SQLite Inner join is the most common type of join. It is used to combine all rows from…
-
SQLite strftime Function The SQLite strftime function is a very powerful function which facilitates you to fetch date and time and also…
-
Connect SQLite with PHP For Connecting SQLite database with PHP, you must have PHP and SQLite installed on your system. If sqlite…