SQLite

Installation

Ubuntu 20.04.4 LTS

sudo apt install sqlite

Basic Usage

Create a database:

sqlite3 example.db

Quit:

.quit

Drop Table

.schema

drop table blogpost;

.quit

Add Column

For adding a new column to an existing table you would use something like this:

ALTER TABLE blogpost ADD comments CHAR(32);