SQLite Database

2.

Getting Started with SQLite

2.1.

Installation and Setup

2.1.1.

Downloading Precompiled Binaries

2.1.1.1.

Official Website Sources

2.1.1.2.

Platform-Specific Packages

2.1.2.

Integration with Operating Systems

2.1.2.1.

2.1.2.2.

2.1.2.3.

2.1.3.

Verifying Installation

2.2.

The SQLite Command-Line Interface

2.2.1.

Starting the CLI

2.2.1.1.

Launching from Terminal or Command Prompt

2.2.2.

Opening and Creating Database Files

2.2.2.1.

Creating New Database Files

2.2.2.2.

Opening Existing Databases

2.2.2.3.

Using In-Memory Databases

2.2.3.

Special Dot-Commands

2.2.3.1.

.help for Command Reference

2.2.3.2.

.databases to List Attached Databases

2.2.3.3.

.tables to List Tables

2.2.3.4.

.schema to View Table Definitions

2.2.3.5.

.quit and .exit to Leave the CLI

2.2.3.6.

.output to Redirect Output

2.2.3.7.

.import for Importing Data

2.2.3.8.

.export for Exporting Data

2.2.3.9.

.mode for Output Formatting

2.2.3.10.

.headers for Column Headers

2.2.3.11.

.read for Executing SQL Scripts

2.2.3.12.

.dump for Database Backup

2.3.

Creating Your First Database

2.3.1.

Creating an In-Memory Database

2.3.2.

Creating an On-Disk Database

2.3.3.

Verifying Database Creation

2.3.4.

Basic Database File Management

Previous

1. Introduction to SQLite

Go to top

Next

3. Core SQL Concepts and Data Definition