Practical solutions

SQLite Howtos How-To Guides

Solve the problem. Keep building. Collection of SQLite how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

SQLite InsertHow to INSERT a New Record or UPDATE One if It Already Exists in SQLiteThis 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. SQLite VariableHow to Declare and Use Variables in SQLiteThis article discusses the declaration and usage of variables in SQLite. SQLite CSVHow to Save the Query Result Into a CSV File in SQLiteIn this article, we discuss how to save SQLite query results to the CSV file. SQLite StringHow to Do Case-Insensitive String Comparison in Sqlite3In this article, we discuss the case-insensitive string comparison in SQLite version 3. SQLite TableHow to Delete All Records From Table in SQLite With AndroidIn this article, we discuss how to delete all records from a table in SQLite with android. SQLite ColumnHow to Add a New Column in Between Two Columns in SQLiteIn this article, we discuss how to insert or add a new column to the existing database. SQLite TimestampHow to Get Automatic Timestamp in SQLiteIn this article we discuss how to get the automatic timestamp in SQLite. SQLite ExtensionFile Extensions for SQLite Database FilesIn this article, we discuss the file extensions for SQLite database files. SQLite NULLSQLite Equivalent to ISNULL(), NVL(), IFNULL(), or COALESCE()In this article, we discuss about the related equivalent ISNULL() functions in the SQLite database. SQLite DatabaseSQLite DateTime ComparisonIn this article, we discuss how to compare different date-time formats in SQLite database SQLite TableSQLite Describe a TableThis article explains SQLite describe tables, syntax as well as its functionality. SQLite Data TypeSQLite Data TypesThis article discusses the various data types in SQLite. SQLite RegexRegex Operator in SQLiteThis article explains everything you need to know to use the regex operator correctly. SQLite PasswordEncryption and Password Protection in SQLiteThis article discusses the methods with which your databases can be password protected and encrypted. SQLite DatatypeBoolean Datatype in SQLite DatabaseLearn about the Boolean Datatype in SQLite Database.