Trying to query my database, what am I doing wrong?

Hey everybody, I’m working through the tutorial video on this page: https://www.codecademy.com/courses/learn-sql/articles/what-is-sqlite and having trouble getting the SELECT * from states query to work. See screen shot for an example of what I’m typing. I’m using gitbash on windows. What’s the fix?

Solved it. I was forgetting the “;” ending

For anyone in a similar position, the query should look like:

sqlite> SELECT * from states;

3 Likes

Ah, yes, the missing semicolon. Been there! :woman_facepalming:t2:

One thing that might help with debugging code is to read it from the bottom to the top. It makes your brain see/interpret it differently and you are more liable to see errors that way.

Happy coding!

2 Likes

Thanks for the tip @lisalisaj ! Appreciate it :slightly_smiling_face:

1 Like