Conslder the table structure shown Table: invoices Column Name ata Type Nullable

Question

Conslder the table structure shown Table: invoices Column Name ata Type Nullable Nullable Default Data Constraint No No No PK FK Invoice ld vendor id rivoice_number varchar 2/50 invaice date Invoioe total numben9,No date redit tatal terms ld invoice due date date payment date date Write a command to add a row to this table wher all felds that can be left null are left null Tha involce to be added is from a vendor with an ld of 130. Tarms lds are from 1 through 5. All the other data should be invented by you, but it must make sense in a business contaxt number(9,2) No No FK

Explanation / Answer

INSERT INTO Invoices (invoice_id, vendor_id, invoice_number, invoice_date,
invoice_total, terms_id, invoice-due_date)
VALUES (1, 130,'ivx234','11/12/2017', 234.54, 2, 1/1/2018);

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.