Create MySQL Database

You will use MySQL Workbench to create the My Guitar Shop database to review the tables in this database and to enter SQL statements and run them against this database.

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 isn$$t$,$ start it$.$

Use MySQL Workbench to create the My Guitar Shop database.

Download and open the script file named my$\_$guitar$\_$shop.sql Download my$\_$guitar$\_$shop.sqlby 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. Take a screenshot.

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

Take a resulting screenshot.

Delete the e at the end of product$\_$name and run the statement again. Note the error number and the description of the error. Take a resulting screenshot.

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

Download and open the script named product$\_$details.sql Download product$\_$details.sql$.$ Note that this script contains just one SQL statement. Then, run the statement. Take a resulting screenshot.

Download and open the script named product$\_$summary.sql Download product$\_$summary.sql$.$ Note that this opens another SQL editor tab. Then, run the statement. Take a resulting screenshot.

Download and open the script named product$\_$statements.sql Download product$\_$statements.sql$.$ Notice that this script contains two SQL statements that end with semicolons. Then, run the statement. Take a resulting screenshot.

All the screenshots should show current date. Example of screenshot.