multiple insert statements(SQL)....?

[GSXdan]

Is there a way to insert multiple values in one INSERT statement?

For example:

INSERT INTO 'phonebook' ('id', 'fname', 'lname')
VALUES ('1', 'dan', 'smith')
VALUES ('2', 'joe', 'smith');
.....

^^^i know that is not correct syntax, but is there a way to do that? I keep getting errors no matter what way i try it.

TIA ^dan

[doctorgonzo]

No, you will need a seperate insert statement for each record you want to insert in that way. Insert statements can only add more than one record using SELECT statements, like INSERT INTO phonebook (ID, FNAME, LNAME) SELECT ID, FNAME, LNAME FROM another_table