SQLite

How-tos How to Open a Database File From SQLite This article explains how to use the open command of SQLite. ↗ How-tos How to INSERT a New Record or UPDATE One if It Already Exists in SQLite This article explains how to use the INSERT, UPDATE, and INSERT OR UPDATE commands. This also discusses how to insert a new record or update a record if it already exists. ↗ How-tos How to Declare and Use Variables in SQLite This article discusses the declaration and usage of variables in SQLite. ↗ How-tos How to Save the Query Result Into a CSV File in SQLite In this article, we discuss how to save SQLite query results to the CSV file. ↗ How-tos How to Do Case-Insensitive String Comparison in Sqlite3 In this article, we discuss the case-insensitive string comparison in SQLite version 3. ↗ How-tos How to Delete All Records From Table in SQLite With Android In this article, we discuss how to delete all records from a table in SQLite with android. ↗ How-tos How to Add a New Column in Between Two Columns in SQLite In this article, we discuss how to insert or add a new column to the existing database. ↗ How-tos How to Get Automatic Timestamp in SQLite In this article we discuss how to get the automatic timestamp in SQLite. ↗ How-tos File Extensions for SQLite Database Files In this article, we discuss the file extensions for SQLite database files. ↗ How-tos SQLite Equivalent to ISNULL(), NVL(), IFNULL(), or COALESCE() In this article, we discuss about the related equivalent ISNULL() functions in the SQLite database. ↗ How-tos SQLite DateTime Comparison In this article, we discuss how to compare different date-time formats in SQLite database ↗ How-tos SQLite Describe a Table This article explains SQLite describe tables, syntax as well as its functionality. ↗ How-tos SQLite Data Types This article discusses the various data types in SQLite. ↗ How-tos Regex Operator in SQLite This article explains everything you need to know to use the regex operator correctly. ↗ How-tos Encryption and Password Protection in SQLite This article discusses the methods with which your databases can be password protected and encrypted. ↗ How-tos Boolean Datatype in SQLite Database Learn about the Boolean Datatype in SQLite Database. ↗