0

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.

3

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                                                  
birth
1988
~/pset7/movies/ $ 
| improve this answer | |
  • Thank you so much. I was doing it in sqlite3. – Afrah Saleem Apr 1 at 18:34
  • @AfrahSaleem You're welcome. Can you please accept my answer so this can be closed/ Thanks! – curiouskiwi Apr 2 at 21:58

You must log in to answer this question.

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