Sql basics

[Suz]

Dear Expert,

I have just started to self teach myself on this website about SQL. I'm on lesson 5 "Inserting into a table". The question asks to insert x3 records into a table. I have created the table the beginning bit correctly but then when I tried several times to "insert into" the records following the website's format I keep coming up with errors and don't know what I'm doing wrong. For example, an example of a record I'm inserting is as thus:

insert into companyemployees_sp2010

(firstname, lastname, title, age, salary)

values ('Jonie', 'Weber', 'Secretary', 28, 19500.00);

('Potsy', 'Weber', 'Programmer', 32, 45300.00);

The above is an example of 2 out of 3 records to be inserted. What do you think I'm doing wrong. Please help. Is there too many spaces, missed commas. Look forward to hearing from you.

Regards
Suz

[rmiao]

Can't insert multiple rows in single insert statement.