Ask Question
28 March, 19:47

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?

+1
Answers (2)
  1. 28 March, 20:00
    0
    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
  2. 28 March, 20:05
    0
    There are few values in the list. So, this insert statement will not be executed.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Insert Into invoices (vendor_id, invoice_number, invoice_total, payment_total, credit_total, terms_id, invoice_date, invoice_due_date) ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers