Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Import data from CSV

We are going to see two ways to import data from CSV.

First we let SQLite create the table based on the first row in the CSV file.

Then we’ll create the table ourselves setting the column types as we prefer and then import the CSV file skipping the first row.