Question

Write an INSERT statement that adds these rows to the Invoice_Line_Items table: invoice_sequence12 account_number160527 line_item_amount $180.23$254.35 line_item_descriptionHard driveExchange Server update Set the invoice_id column of these two rows to the invoice ID that was generated by MySQL for the invoice you added in step 2 above.

Answer 1

Answer:

Insert into Invoice_line_items table (Invoice_sequence, account_number,line_item_amount,line_item_description)

Values ( 1,160,$180.23,Hard drive)

values (2,527,$254.35,Exchange Server)

update statement

Update Invoice_Line_items table

set invoice_sequence = 'new values'

Explanation:

New values being the values generated by MySQL for the invoice. Those values are not available in the question.

invoice_sequence acted as invoice ID