Import CSV with mode and separator

text

.mode csv
.import ./users.csv users

Explanation

A reliable shell pattern when loading CSV into an existing table.

Learn the surrounding workflow

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

Same sheet · prioritizing Move data in and out

Write selected rows to a CSV file.

Open In sheettextsame section

Export only selected table schema and data.

Open In sheettextsame section

Execute inserts and DDL from a seed script.

Open In sheetbashsame section

Create a backup from inside sqlite3.

Open In sheettext1 tag match

Write a fresh copy of the database to a new file.

Rebuild the database file and reclaim free space.