In these exercises, you’ll use MySQL Workbench to review the tables in the AP database. In addition, you’ll use MySQL Workbench to enter SQL statements and run them against these tables. Make sure the MySQL server is running 1. Start MySQL Workbench and open a connection for the root user.
2. Check whether the MySQL server is running. If it isn’t, start it. When you’re done, close the Startup/Shutdown window. Use MySQL Workbench to review the Accounts Payable (AP) database
3. In the Navigator window, expand the node for the AP database so you can see all of the database objects it contains.
4. View the data for the Vendors and Invoices tables. Chapter 2 How to use MySQL Workbench and other development tools 71
5. Navigate through the database objects and view the column definitions for at least the Vendors and Invoices tables. Use MySQL Workbench to enter and run SQL statements
6. Double-click the AP database to select it. When you do that, MySQL Workbench should display the database in bold.
7. Open a SQL Editor tab. Then, enter and run this SQL statement: SELECT vendor_name FROM vendors
8. Delete the e at the end of vendor_name and run the statement again. Note the error number and the description of the error.
9. Open another SQL Editor tab. Then, enter and run this statement: SELECT COUNT(*) AS number_of_invoices, SUM(invoice_total) AS grand_invoice_total FROM invoices Use MySQL Workbench to open and run scripts
10. Open the select_vendor_city_state script that’s in the c:\murach\mysql\scripts\ch02 directory. Note that this script contains just one SQL statement. Then, run the statement.
11. Open the select_vendor_total_due script that’s in the ch02 directory. Note that this opens another SQL Editor tab.
12. Open the select_vendor_information script that’s in the ch02 directory. Notice that this script contains two SQL statements that end with semicolons (scroll down if you need to).
13. 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 grids. Make sure to view the results of both SELECT statements.
14. Move the insertion point into the first statement and press Ctrl+Enter to run just that statement.
15. Move the insertion point into the second statement and press Ctrl+Enter to run just that statement.
16. Exit from MySQL Workbench.