Question: Using the sakila database in MySQL Workbench, complete the instructions listed below: After opening MySQL Workbench, what commands would you type and execute in the
Using the "sakila" database in MySQL Workbench, complete the instructions listed below: After opening MySQL Workbench, what commands would you type and execute in the sakila database to review the information in ALL the columns in the Store table? In the existing query window, what commands would you use that will add the following rows to the actor table? PATRICK ROBERTS and ANNIE SMITH In the existing query window, what commands would you use to delete the following rows from the Staff table using the Delete statement? Jon Stephens . Note ONLY SQL statement is requested here as deletion won't be possible because unless linked records are deleted. In the existing query window, what commands would you use to update the email address (Email) for HILYER in the Staff table using the Update statement? update it to "Hillyer.Mike@sakilastaff.com" . Remember , that if using workbench, unique identifier (primary key) needs to be added in the condition. If using command line however, unique identifier for record is not needed.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
