Question

Assuming that all of the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?

INSERT INTO invoices
(vendor_id, invoice_number, invoice_total, payment_total, credit_total,
terms_id, invoice_date, invoice_due_date)
VALUES
(97, '456789', 8344.50, 0, 0, 1, '2012-08-31')
A. There are too few items in the VALUES list.
B. The column names in the column list are in the wrong sequence.
C. The number of items in the column list doesn't match the number in the VALUES list.
D. There are too many items in the column list.

Answer 1

C. The number of items in the column list doesn't match the number in the VALUES list.

Step-by-step explanation:

The INSERT INTO statement is used to insert new records in a table.

Syntax is as follows:

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...);

Each column item has to match with the values to be inserted in the same order.

In the question, there are 8 column items specified whereas there are only 7 values given to be inserted.