-
SQL Course Lesson 5
Could someone help me get past lesson 5 of the first SQLCourse.com? I keep
putting in what I feel are the right commands for inserting records, but
keep getting an error, for weeks now.
Here's the code I put:
insert into employee_jvd0515
(first, last, title, age, salary)
values('Jonie', 'Weber', 'Secretary', 28, 19500.00);
The table, with those fields, was successfully created previously.
Help. Thanks.
Vince Deegan
-
vdeegan, I just tried it, and it worked, but you must go through the procedures in order...first I created the table thusly:
create table myemployees_jvd0515(firstname varchar(30),
lastname varchar(30),
title varchar(30),
age number(2),
salary number(8,2));
then I inserted the data:
insert into myemployees_jvd0515
(firstname, lastname, title, age, salary)
values ('Jonie', 'Weber',
'Secretary', 28, 19500.00);
No problems at all. Try again using a different table name and you shouldn't have any problems.
-
I had been creating the table before doing any inserts. I tried it again exactly like you did it, but I'm still getting the same old error message. Don't know why it doesn't work when I do it and why it works when you do it. We're apparently doing the exact same thing. Again, here's my syntax:
create table
employee_vince0515
(first varchar(30),
last varchar(30),
title varchar(30),
age number(2),
salary number(8,2));
Then,
insert into
employee_vince0515
(first,last,title,age,salary)
values
('Jonie','Weber','Secretary',28,19500.00);
I tried it several ways:
1) Did the create in lesson 4 and the insert in lesson 5.
2) Did the create in the first query window of lesson 5 and the insert in the second query window of lesson 5.
3) Did the create followed by the insert as a separate statement, both in the first query window of lesson 5.
Nothing works. Help again. Thanks.
-
I'm stumped...I just tried it again, just cutting and pasting from the thread above. I created the table, then populated it, and didn't have any problems. Are you manually typing the text in, or cutting and pasting? You may need to change the table name...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|