Mention some SQLite commands and also explain them?

The SQLite commands interact directly with relational databases and are similar to SQL.
Below are the standard SQLite commands which are classified based on their operational nature.
Data Definition Language: It provides storage structures and methods to access data from the database system.

• CREATE
• ALTER
• DROP

Data Manipulation Language: It allows user to manipulate (add/delete/modify) data.

• INSERT
• UPDATE
• DELETE

Data Query Language: It allows the user to retrieve data from the database.

• SELECT