Skip to content

Latest commit

 

History

History
16 lines (15 loc) · 727 Bytes

README.md

File metadata and controls

16 lines (15 loc) · 727 Bytes

Commands:

  1. Connect to database and open CLI: sqlite3 aquarium.db
  2. See available commands: .help
  3. Quit with: .quit
  4. Open sqlite3 without connecting to database: sqlite3
  5. Connect to database after starting sqlite3: .open FILENAME
  6. See connected databases: .databases
  7. See tables in database: .tables
  8. See the command used to create the table: .schema TABLE
  9. See indexes: .indexes
  10. Execute some SQL statements:
    - select * from animals;
    - select * from animals where tank_number = 1;
    - select species, count(*) as count from animals group by species order by count desc limit 1
    - select distinct species from animals order by species asc