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.

Improve this question

1 Answer 1

Reset to default
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
2
  • Thank you so much. I was doing it in sqlite3.
    – Afrah Saleem
    Commented Apr 1, 2020 at 18:34
  • @AfrahSaleem You're welcome. Can you please accept my answer so this can be closed/ Thanks!
    – curiouskiwi ♦
    Commented 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 .