Running Queries while practicing SQL


#1

Is it just me, or is there no option to run a query while practicing SQL....? :cry:


#2

The Save button will run your query.


#3

In that case, the save button is not fully responsive because it does not run my query or at the very least display an error if my code was incorrect.


#4

If you tell me which exercise and what your code is then I can give it a try.


#5

Are you suggesting that the query simply doesn't run if there's an error?


#6

I've seen the thing just spin until I reloaded the page when I was missing a semicolon.


#7

In my case it doesn't just spin endlessly, I'll get a "Saved" message and the live view isn't updated


#8

Is one of your SQL statements a SELECT statement?


#9

Nope, I've been trying to create the table... Haven't been able to do that or get past that


#10

Did you want me to try out your code?


#11

I am having the same problem with lesson 4, it just saves and nothing else happens. below is the code. I have re-entered it multiple times and refreshed the page, nothing seems to work, unless I am completely blind and can't see my obvious error.

CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Bieber', 21);
SELECT * FROM celebs;


#12

If you have that statement in then the code checker will fail. It can't seem to get past it to see your INSERT statement. Take that line out and you should be fine.


#13

perfect! Thank you so much albionsrefuge!