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, '31-AUG-08'). What's wrong with this?

Question

Computers & Technology

Taylor Alvarado

18 February, 16:02

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, '31-AUG-08'). What's wrong with this?

+5

Answers (2)

Know the Answer?

Amaris Salazar · Answer 1

There are few values in the list. So, this insert statement will not be executed.

Leandro Daniels · Answer 2

Answer in explanation

Explanation:

In the table to fill, there are 7 attributes aside the index column to fill, making a total of 8 columns to fill.

Now, in the values part of the query, it can be seen that we only have inputs for 7 out of the 8 columns to fill. Hence, we can say that the number of columns to fill with the different values is incomplete and there is a need to check the values side of the query to ensure that complete information is supplied.

To be properly specific, considering the type of data to be inputed, there is a date stamp format to be filled in both the invoice_date and invoice_due_date columns. But checking the values, we can see we only have one date format. Hence, the query is expected to return an error