SQLite Create Table Summary: in this tutorial, you will learn how to create new tables using SQLite CREATE TABLE statement using various options. Introduction to SQLite CREATE TABLE statement To create a new table in SQLite, you use CREATE TABLE statement using the following syntax: CREATE TABLE [IF NOT EXISTS] [schema_name].table_name ( column_1 data_type PRIMARY…
Read more
SQLite Data Types Summary: in this tutorial, you will learn about SQLite data types system and its related concepts such as storage classes, manifest typing, and type affinity. Introduction to SQLite data types If you come from other database systems such as MySQL and PostgreSQL, you notice that they use static typing. It means when…
Read more
SQLite Transaction Summary: in this tutorial, we will show you how to use the SQLite transaction to ensure the integrity and reliability of the data. SQLite & ACID SQLite is a transactional database that all changes and queries are atomic, consistent, isolated, and durable (ACID). SQLite guarantees all the transactions are ACID compliant even if…
Read more
SQLite REPLACE Statement Summary: in this tutorial, you will learn how to use the SQLite REPLACE statement to insert or replace the existing row in a table. Introduction to the SQLite REPLACE statement The idea of the REPLACE the statement is that when a UNIQUE or PRIMARY KEY constraint violation occurs, it does the following:…
Read more
SQLite Delete Summary: This tutorial shows you how to use SQLite DELETE statement to remove rows from a table. Introduction to SQLite DELETE statement You have learned how to insert a new row into a table and update the existing data of a table. Sometimes, you need to remove rows from a table. In this…
Read more
SQLite Update Summary: in this tutorial, you will learn how to use SQLite UPDATE statement to update data of existing rows in the table. Introduction to SQLite UPDATE statement To update existing data in a table, you use SQLite UPDATE statement. The following illustrates the syntax of the UPDATE statement: UPDATE table SET column_1 =…
Read more
SQLite Insert Summary: in this tutorial, you will learn how to use SQLite INSERT statement to insert new rows into a table. To insert data into a table, you use the INSERT statement. SQLite provides various forms of the INSERT statements that allow you to insert a single row, multiple rows, and default values into…
Read more
SQLite CASE Summary: in this tutorial, you will learn about the SQLite CASE expression to add conditional logic to a query. The SQLite CASE expression evaluates a list of conditions and returns an expression based on the result of the evaluation. The CASE expression is similar to the IF-THEN-ELSE statement in other programming languages. You…
Read more
SQLite EXISTS Summary: in this tutorial, you will learn how to use the SQLite EXISTS operator to test for the existence of rows returned by a subquery. Introduction to SQLite EXISTS operator The EXISTS operator is a logical operator that checks whether a subquery returns any row. Here is the basic syntax of the EXISTS…
Read more
SQLite Subquery Summary: in this tutorial, you will learn about the SQLite subquery to construct more readable and complex queries. Introduction to SQLite subquery A subquery is a SELECT statement nested in another statement. See the following statement. SELECT column_1 FROM table_1 WHERE column_1 = ( SELECT column_1 FROM table_2 ); The following query is…
Read more