mirror of
https://github.com/ivuorinen/cheatsheet-tldr.git
synced 2026-01-26 11:33:59 +00:00
22 lines
533 B
Plaintext
22 lines
533 B
Plaintext
---
|
|
syntax: markdown
|
|
tags: [tldr, common]
|
|
source: https://github.com/tldr-pages/tldr.git
|
|
---
|
|
# sqlite3
|
|
|
|
> Interface to SQLite 3, which is a self-contained file-based embedded SQL engine.
|
|
> More information: <https://sqlite.org/cli.html>.
|
|
|
|
- Start an interactive shell with a new database:
|
|
|
|
`sqlite3`
|
|
|
|
- Open an interactive shell against an existing database:
|
|
|
|
`sqlite3 {{path/to/database.sqlite3}}`
|
|
|
|
- Execute an SQL statement against a database and then exit:
|
|
|
|
`sqlite3 {{path/to/database.sqlite3}} '{{SELECT * FROM some_table;}}'`
|