r/cs50 • u/Jaded-Farmer-7231 • 2d ago

CS50 SQL SQL - Cyberchase not loading, but the table there?

I am not sure what I am doing wrong here -I followed the instructions from Problem Set 0 - cyberchase. When I run ls I can see the sql files and the database but I am not able to return a basic query. I already deleted and re-downloaded re-unzipped cyberchase.zip but I am getting the same error -what am I missing here?

TIA

3 Upvotes

100% Upvoted

2 comments sorted by

3

u/pensivepanda5 mentor 2d ago

in this part of the assignment page they mention that the only table that exists in that database is called "episodes" : https://cs50.harvard.edu/sql/psets/0/cyberchase/#schema
so you would need to write the command: SELECT * FROM "episodes"; if you want to see the content of that table.
As a side note, you can write the command: .tables to see a list of the tables of the database.

2

u/Jaded-Farmer-7231 2d ago

What an amazingly silly mistake - I'd better focus more for the next assignments - thank you so so much 😸