SQL Course, Stuck at lesson 5 (Resolved)
I'm and just started doing an online SQL course at:
http://sqlcourse.com/
The site let's you interactively test SQL lines.
They have a forum that I've posted to, but no-one seems to be 'home'
In lesson 4 you make a table.
I did that without a problem, and it showed me the table headers.
Here's my (masked) string
Code:
create table myemployees_jpXXX
(first varchar(30),
last varchar(30),
title varchar(30)
age number(3),
salary number(8,2));
In lesson 5 you start populating the table.
No matter what I try, I get this:
"Error occured. Recheck your SQL statement"
Here's my 1st Insertion string:
Code:
insert into myemployees_jpXXX
(first, last, title, age, salary)
values ('Jonie', 'Weber', 'Secretary', 28, 19500.00);
Did I make a mistake?
Or maybe their page isn't working right?
Re: SQL Course, Stuck at lesson 5
never mind, I found it.
I was missing a comma after this line:
title varchar(30)
So the table didn't have an age column.
I'm just surprised I didn't get an error when I did the create table call.