SQLite Basics

  • sqlite3 - Start SQLite
  • sqlite3 NAME.db - Create database
  • .database - Show Database names and files
  • .tables - List tables
  • .open NAME.db - Open a database file / link it to database