This guide shows how you can perform queries with MySQL Workbench database client application to preferred database.
As a pre-requisite, you should have Northwind exercise database prepared (if you don't, check this guide first).
Below is a brief presentation of MySQL Workbench application window contents.
Follow the instructions below to perform some test queries on your Northwind database and familiarize yourself with functionality of MySQL Workbench application.
Start XAMPP and your MySQL server.
Start Workbench application. Open your previously saved database connection (to Labranet or your XAMPP hosted local database).
If your connection was successfully established, you should get the window like presented in the example above.
Select your previously created exercise database as a default database (Right click → Set as Default Schema).
Run the following example query to your exercise database: SELECT * FROM categories;
You should now see the results in the result window on the bottom of the application.
In addition, you should see the confirmation in the Action output window that 11 rows were returned.
