I am trying to test the queries I've saved in files i.e. 1.sql, 2.sql,.... But I can't able to test them in the terminal window. The command given in the instruction is not showing any results. However .schema is working fine. The cat filename.sql | sqlite3 movies.db is not showing any results.

1 Answer 1


Are you running that in the terminal? (ie, not inside sqlite3)? A common problem is trying to run it at the sqlite3 prompt.

~/pset7/movies/ $ cat 2.sql | sqlite3 movies.db                                                  
~/pset7/movies/ $ 
  • Thank you so much. I was doing it in sqlite3. Apr 1, 2020 at 18:34
  • @AfrahSaleem You're welcome. Can you please accept my answer so this can be closed/ Thanks!
    – curiouskiwi
    Apr 2, 2020 at 21:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .