![3345](/avatars/11277.jpg)
3345
21.09.2020 •
Computers and Technology
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.
Solved
Show answers
More tips
- S Science and Technology The Metric System in Our Daily Life: Understanding Its Importance...
- H Health and Medicine Angina: Causes, Symptoms, and Treatment...
- C Computers and Internet How to Learn to Type Fast?...
- F Food and Cooking Delight for Gourmets: How to Prepare Liver Pate...
- S Style and Beauty How to braid friendship bracelets?...
- H Health and Medicine Mercury Thermometer Danger: What to do when a thermometer breaks?...
- F Food and Cooking Which Calamari Salad is the Most Delicious?...
- S Society and Politics 10 Tips for Boosting Your Self-Esteem...
- F Food and Cooking The Most Delicious and Simple Fish in Batter Recipe...
- H Health and Medicine What is Autism? Understanding the Basics of This Neurodevelopmental Disorder...
Answers on questions: Computers and Technology
- C Computers and Technology New Super Mario Bros am I right ...
- C Computers and Technology What is defined as a set of machine-readable instructions that directs a computer s processor to perform specific operations?...
- C Computers and Technology Sahil is making a graphic novel in which the villain plans to reduce the rate at which energy is released from the sun. the villain’s device can make a hollow sphere...
- M Mathematics The lunch special at Abdul s Restaurant is a sandwich, a drink and a dessert. There are 3 sandwiches, 5 drinks, and 2 desserts to choose from. How many lunch specials...
- H Health hi everyone did u guys seen alex it show a picture of him wearing a blue sweatshirt on if you do find him let me know plz...
- C Chemistry 14 Select the correct answer. A compound has an empirical formula of CzHs. What is true about this empirical formula? O A. It models the structure of the compound....
- B Business 7. Give me your pen, please...
- M Mathematics P(-3,-5) and Q(1, -3) represent points in a coordinate plane. Find the midpoint of PQ....
- H History 2) How are 14th Amendment due process protections related to the Civil Rights Act of 1968? a) Congress may not enact discriminatory housing statutes. b) Congress...
- H History I need an essay answering what was the impact of the printing press? NEED HELP ASAP...
Ответ: