SQL statement
One complete SQL command, such as a SELECT, INSERT or CREATE TABLE, normally ending with a semicolon.
In more detail
Statements that read data return rows; statements that change data or structure usually return nothing but a count of affected rows. In the sqlite3 shell a statement runs when you type the closing semicolon.
Related terms
- SQL — The standard language for defining, querying and changing data in a relational database.
- query — A request to a database for data, written in SQL, that returns a set of rows as its answer.
- sqlite3 shell — The command-line program that opens a SQLite database file and lets you type SQL and see the results.
Taught in
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling