Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Execute SQL from a file

Run a script inside the shell.

Back to sheetBrowse commands
Sign in to save
Section: Output, import, and export

Execute SQL from a file

text
text
.read ./schema.sql
Explanation

Useful for schema initialization, migrations, or repeatable demos.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Output, import, and export
Show column headers
Enable headers in tabular output.
OpenIn sheettextsame section
Use aligned column output
Render query results in a readable table.
OpenIn sheettextsame section
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Import a CSV file into a table
Load rows from CSV using the shell importer.
OpenIn sheettextsame section
Dump the full database as SQL
Export schema and data as executable SQL.
OpenIn sheettextsame section
Write the next query result to a file
Send one result set to a file without changing subsequent output.
OpenIn sheettextsame section