Question: Using MySQL Workbench. Write an UPDATE statement that modifies the Invoices table. Change the terms_id column to 2 for each invoice that's for a vendor

Using MySQL Workbench.

Write an UPDATE statement that modifies the Invoices table. Change the terms_id column to 2 for each invoice that's for a vendor with a default_terms_id of 2.

What I have tried and their errors:

UPDATE invoices SET terms_id = 2 WHERE vendor_id in (SELECT vendor_id FROM vendors WHERE default_terms_id = 2);

ERROR MESSAGE: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

UPDATE invoices SET terms_id = 2 WHERE vendor_id = (SELECT vendor_id FROM vendors WHERE default_terms_id = 2);

ERROR MESSAGE: Subquery returns more than one row

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Insert, update, and delete data Use your copy of the ap database: _ap If you need to restore the database to the original state, you can modify and run the create_db_ap script to restore it. To test...

that Problems 5-9 may refer to the invoice_id created in Problem 4: you can get that by visually ipect the invoice_id created in the query for Problem 4. To test whether a table has been modified...

Note that Problems 5-9 may refer to the invoice_id created in Problem 4: you can get that by visually inspect the invoice_id created in the query for Problem 4. To test whether a table has been...

1. Write an INSERT statement that adds this row to the Terms table: terms_id: 6 terms_description: Net due 120 days terms_due_days: 120 Use MySQL Workbench to review the column definitions for the...

5. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: (All in MySQL) invoice_sequence: 1 2 Account_number: 160 527 line_item_amount: $180.23 $254.35...

please answer by SQL Language. and show a screen shot for your work and run in your computer thank you 5. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: rver update...

Please Write SELECT INTO statements to create one test table named Vendor-Invoice that contain the results of a natural join between the Vendors and Invoices tables; Please Write an INSERT statement...

Learning Activity 6 : Insert, update, and delete data Setup: Use create _ ap . sql to create database 1 . Write SELECT INTO statements to create two test tables named VendorCopy and InvoiceCopy that...

This is in SQL 5. Write an UPDATE statement that modifies the InvoiceCopy table. Change the PaymentDate to todays date and the PaymentTotal to the balance due for each invoice with a balance due. Set...

In a certain chemical plant, a reversible fluid-phase isomerization A?B is carried out over a solid catalyst in a tubular packed-bed reactor. If the reaction is so rapid that mass transfer between...

my dashboard | my account Student Home Contact My Instructor EMT TRAUMA UNIT EXAM 0 1 : 2 0 : 0 4 Remaining 7 5 Qu Question # 4 4 discuss in class teve Which of the following is the most common cause...

Which RAID solution would you recommend for a database system that requires high data transfer rates and hard drive redundancy? Group of answer choices RAID 0 RAID 0 + 1 RAID 1 JBOD