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;
Ah, yes, the missing semicolon. Been there!
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.
Thanks for the tip @lisalisaj ! Appreciate it