I tried writing the instructed code:
SELECT * FROM celebs;
But it just comes back with:
Error: near line 1: no such table: celebs
Tried it in chrome, Firefox and IE and get the same error. Any suggestions?
Im preety sure your suppose to create the table celebs then... Try this?
CREATE TABLE celebs
Fill column with your needs.. Hope this works..
I'm sure that will work but the instructions simply state to type in SELECT * FROM celebs; and click run. The next screen says, "Nice work. In one line of code, you returned information from a relational database" which implies it should have returned a result without having to add additional code.
Am I right in saying I shouldn't be require augmenting the code to get it to work? in which case is the coarse bugged at lesson 1?!
Wow @identityflux i actually faced this bug!
So yes, there is a high chance this lesson is bugged. But did you pass the lesson? if you didnt try to do the same exact code i did on the topic i posted.. then it will create the table celebs..
Reset the lesson, copied to text again (which I'd already done) and it worked. Restarting it seemed to clear the issue.
Thanks for the info.
how to reset the lesson?
I'm currently having this same problem too. I've been trying to reset but to no avail. Any other suggestions please?