Sqlite
SQLite ALTER TABLE Statement
SQLite ALTER TABLE Statement
The SQLite ALTER TABLE statement is used to modify an existing database table. We can use this statement ...
SQLite UPDATE Statement
SQLite UPDATE Statement
The SQLite UPDATE Statement is used to modify the existing data in a table. We can use the WHERE clause to ide...
SQLite Delete Statement
SQLite Delete Statement
In this tutorial, we will learn about the SQLite DELETE Statement. The DELETE statement is used to delete the ...
SQLite Like Operator
SQLite Like Operator
The SQLite LIKE operator matches text values against a pattern using wildcards. This operator can be used to filt...
SQLite LIMIT Clause
SQLite LIMIT Clause
The SQLite LIMIT clause limits the number of rows the SELECT statement returns. This is useful when we query a lar...
SQLite CREATE INDEX Statement
SQLite CREATE INDEX Statement
The SQLite CREATE INDEX statement is used to create an index on one or more columns of a database table....
SQLite PRAGMA Statement
SQLite PRAGMA Statement
The SQLite PRAGMA statement is used to query or modify various aspects of the SQLite database. PRAGMA statemen...
SQLite IN Clause
SQLite IN Clause
Let's learn about the SQLite IN clause. The SQLite IN clause specifies a range of values for a WHERE condition.
Synt...
SQLite LOWER() Function
SQLite LOWER() Function
The SQLite LOWER() Function converts a string into lowercase letters. We can use this function to convert colu...
SQLite UPPER() Function
SQLite UPPER() Function
The SQLite UPPER() function converts a string into uppercase letters. We can use this function to convert colu...