TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQLite Commands
SQLite Commands with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite
SQLite CommandsSQLite commands are similar to SQL commands. There are three types of SQLite commands:
Data Definition Language
There are three commands in this group: CREATE: This command is used to create a table, a view of a table or other object in the database. ALTER: It is used to modify an existing database object like a table. DROP: The DROP command is used to delete an entire table, a view of a table or other object in the database. Data Manipulation language
There are three commands in data manipulation language group: INSERT: This command is used to create a record. UPDATE: It is used to modify the records. DELETE: It is used to delete records. Data Query Language
SELECT: This command is used to retrieve certain records from one or more table. SQLite dot CommandFollowing is a list of SQLite dot commands. These commands are not terminated by a semicolon (;). .help command: Check the list of dot commands by using the ".help" at anytime. For example: Sqlite> .help 
The above are the list of various important SQLite dot commands. See these commands with description in the following table:
.show command: You can use the .show command to see default setting of for your SQLite command prompt. 
Note: Don't put space between sqlite> prompt and dot command, otherwise it will not work.Special dot commandsThere are some dot commands which are used to format your output. These commands are: .header on .mode column .timer on
Next TopicSQLite Syntax
|
Related Links:
- Learn SQLite Tutorial
- SQLite History
- SQLite Interview Questions (2021)
- SQLite Data Types
- SQLite Operators
- SQLite Features
- SQLite Advantages and Disadvantages
- SQLite Installation
- SQLite Commands
- SQLite Syntax
- SQLite Expressions
- SQLite Create Database
- SQLite Attach Database
- SQLite Detach Database
- SQLite Create Table
- SQLite Like Clause
- SQLite Drop Table
- SQLite Insert Query
- SQLite Select Query
- SQLite Joins
- SQLite Update Query
- SQLite Delete Query
- SQLite Where Clause
- SQLite And Clause
- SQLite OR Clause
- SQLite Glob Clause
- SQLite Limit Clause
- SQLite Order by Clause
- SQLite juliandday
- SQLite strftime
- SQLite time
- SQLite Group by Clause
- SQLite Having Clause
- SQLite Distinct Keyword
- SQLite Union
- SQLite Union All
- SQLite Inner Join
- SQLite Outer Join
- SQLite Cross Join
- SQLite Date and Time
- SQLite date
- SQLite datetime
- SQLite now
- SQLite Aggregate Functions
- SQLite MIN Function
- SQLite MAX Function
- SQLite AVG Function
- SQLite COUNT Function
- SQLite SUM Function
- SQLite Triggers
- SQLite Trigger After Insert
- SQLite Trigger After Update
- SQLite Trigger After Delete
- SQLite Drop Trigger
- SQLite Primary Key
- SQLite Foreign Key
- SQLite Import
- SQLite Export