Question: Make sure the MySQL server is running Start MySQL Workbench and open a connection for the root user. Check whether the MySQL server is running.

Make sure the MySQL server is running Start MySQL Workbench and open a connection for the root user. Check whether the MySQL server is running. If it isnt, start it. Use MySQL Workbench to create the My Guitar Shop database. Open the script file named my_guitar_shop.sql thats in the mgs_ex_starts directory Download mgs_ex_starts directoryby clicking the Open SQL Script File button in the SQL Editor toolbar. Then, use the resulting dialog box to locate and open the file. Execute the entire script by clicking the Execute SQL Script button in the SQL editor toolbar or by pressing Ctrl+Shift+Enter. When you do, the Output window displays messages that indicate whether the script executed successfully. Use MySQL Workbench to review the My Guitar Shop database In the Schemas category of the Navigator window, expand the node for the database named my_guitar_shop so you can see all of the database objects it contains. If it isnt displayed in the Schemas tab of the Navigator window, you may need to click on the Refresh button to display it. View the data for the Categories and Products tables. Navigate through the database objects and view the column definitions for at least the Categories and Products tables. Use MySQL Workbench to enter and run SQL statements Double-click on the my_guitar_shop database to set it as the default database. When you do that, MySQL Workbench should display the database in bold. Open a SQL editor tab. Then, enter and run this SQL statement: SELECT product_name FROM products Delete the e at the end of product_name and run the statement again. Note the error number and the description of the error. Open another SQL editor tab. Then, enter and run this statement: SELECT COUNT(*) AS number_of_products FROM products Use MySQL Workbench to open and run scripts Open the script named product_details.sql thats in the mgs_ex_starts directory. Note that this script contains just one SQL statement. Then, run the statement. Open the script named product_summary.sql thats in the mgs_ex_starts directory. Note that this opens another SQL editor tab. Open the script named product_statements.sql thats in the mgs_ex_starts directory. Notice that this script contains two SQL statements that end with semicolons. Press the Ctrl+Shift+Enter keys or click the Execute SQL Script button to run both of the statements in this script. Note that this displays the results in two Result tabs. Make sure to view the results of both SELECT statements. Move the insertion point into the first statement and press Ctrl+Enter to run just that statement. Move the insertion point into the second statement and press Ctrl+Enter to run just that statement. Save Your SQL Scripts Create a Folder - LastnameFirstNameExercise1 Add your SQL Scripts to the Folder Zip Your Folder Submit Your Work Exit from MySQL Workbench.

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!