SQLite – DISTINCT Keyword SQLite DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only the unique records. There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of […]
Category Archives: sqlite
SQLite – INSERT Query SQLite INSERT INTO Statement is used to add new rows of data into a table in the database. Syntax Following are the two basic syntaxes of INSERT INTO statement. INSERT INTO TABLE_NAME [(column1, column2, column3,…columnN)] VALUES (value1, value2, value3,…valueN); Here, column1, column2,…columnN are the names of the columns in the table […]
SQLite – Constraints Constraints are the rules enforced on a data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database. Constraints could be column level or table level. Column level constraints are applied only […]