# sqlite3 Guide

## Create Table

``` sql
CREATE TABLE IF NOT EXISTS config (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  user TEXT NOT NULL UNIQUE,
  hashed_password TEXT NOT NULL
);
```

## Add Record to Table

``` sql
INSERT INTO config (user, hashed_password) VALUES ('abc', 'base64 hashed password');
```

## Update Record

``` sql
UPDATE config SET user = 'def' WHERE user = 'abc';
```

## Get All Records from Table

``` sql
SELECT * FROM config;
```

## Get Specific Record Field based on User

``` sql
SELECT hashed_password FROM config WHERE user = 'abc';
```

## Delete Record

``` sql
DELETE FROM config WHERE user = 'abc';
```

## View All Tables

``` sql
.tables
```