Question

What is the correct syntax for inserting more than one record into a table called 'menu' using only one statement?

Question options:

insert into menu (name, price) values ('tacos', 1.0); insert into menu (name, price) values ('pizza', 3.0); insert into menu (name, price) values ('sushi', 4.0);

insert into menu (name, price) values ('tacos', 1.0) values ('pizza', 3.0) values ('sushi', 4.0);

insert into menu ('tacos', 1.0), ('pizza', 3.0), ('sushi', 4.0);

insert into menu (name, price) values ('tacos', 1.0), ('pizza', 3.0), ('sushi', 4.0);

Answer 1

The correct syntax for inserting more than one record into the 'menu' table using only one statement is:

So according to your options, the correct option is the last option mentioned in the question.