Open SQLite3 shell with headers and column mode on:

```
sqlite3 -column -header your_db.db
```

Meta Commands

| Meta Command  | Description |
| ------------- | ------------- |
| .show  | Displays current settings for various parameters  |
| .databases  | Provides database names and files  |
| .tables | Show current tables |
| .quit | Quit |
| .schema | Show schemas of tables |
| .headers | Set headers on or off |
| .mode | Select mode for the output table |

# Data Types


# Create Table

```
CREATE TABLE comments (
	post_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	name TEXT NOT NULL,
	email TEXT NOT NULL,
	website_url TEXT NULL,
	comment TEXT NOT NULL );
```