Computers and Technology, 21.09.2020 23:01 brittany7436

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.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 18:20

Geneva’s manager would like to see some additional information to make sales decisions.enter a formula in cell j4 using the if function to it whether or not the item beaded earrings should go on sale. it will go on sale if its current sales rank (in cell g4) is 8th or lower. (hint: if the cell value is greater than or equal to 8, it will go on sale.)if this condition is true, the item will go on sale. (hint: the if_true value should be “yes”.)if this condition is false, the item doesn’t need to go on sale. (hint: the if_false value should be “-”.)copy the formula created in cell j4 to the range j5: j14

Answers: 2

Answer

Computers and Technology, 22.06.2019 11:00

Technician a says that the radiator usually cools better if the front air dam is removed. technician b says that when a condenser has a leak it can be repaired easily with epoxy. who is correct?

Answers: 1

Answer

Computers and Technology, 22.06.2019 15:30

When creating a budget, log fixed expenses before income. after income. after savings. at the top.

Answers: 1

Answer

Computers and Technology, 22.06.2019 19:30

Singing in the rain: this first part of the film shows the early history of motion picture. how accurate do you think the portrayal of the early motion picture industry is? why? is historical accuracy important in films and theater productions? explain.

Answers: 1

Answer

You know the right answer?

In these exercises, you’ll use MySQL Workbench to review the tables in the AP database. In addition,...

Questions