Ravindra BagaleCourses & study guides Track your progress

2. Install SQLite and DB Browser (Windows and Mac)

2.5 How to Load a .sql Seed File into a New Database

By Last updated:

Why. Sometimes you get a .sql file, not a ready .db.

What. A seed .sql file creates tables and inserts rows when you execute it.

How. New Database → Execute SQL → open seed file → Run → Save.

Steps

  1. File → New Database → pick a folder and name (e.g. practice.db).
  2. Execute SQL tab → Open SQL file → seed_raja_coffee.sql.
  3. Click Run.
  4. Browse Data tab — confirm customers / products / orders exist.
  5. File → Save.

Ravindra Bagale's Tip

If Run fails mid-way, drop tables and re-run the full seed once.