Ex

.docx

School

Pennsylvania State University *

*We aren’t endorsed by this school

Course

210

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

11

Uploaded by BailiffWrenMaster830

Report
Exercise 2.1 Introduction to MySQL Workbench Purpose: To get started using MySQL Workbench and introduce you to the relational model, tables, columns and rows IT Requirements: MySQL Workbench installed on laptops with built-in databases (e.g. Sakila, World) zyBooks: 2.1-2.2 Introduction In this course we will be using the MySQL Workbench to interact with our MySQL Instance. The Workbench is a powerful SQL editor and database tool that provides a graphical method of interacting with databases, tables, and other MySQL features that we would otherwise have to do using the command line (not very friendly). STEPS 1. Connecting to your MYSQL Instance MySQL Workbench requires a connection to your MySQL Instance to operate. The connection was most likely set up when you installed MySQL Workbench. If you are using MySQL on a remote server or if you installed the server and Workbench separately, you might need to set the connection up manually. To do so, click the plus icon next to MySQL connections. 1
Enter the connection name (e.g. Local DB), the IP address of their MySQL Instance, and the user name you want to use to connect. Unless you specifically set things up differently, it is likely the MySQL Instance is on their local machine and the user name is root. In that case, all you need to do is give you connection a name (e.g. Local DB) and click OK. 2
Then click on the connection to open it. 3
2. Explanation of workbench screens Let’s run through what we are seeing on the screen. Query window -- In the center of the screen is the query window where you can write SQL statements. The buttons along the top of the screen allow you to execute all or part of a statement, save or load a statement, or modify the look of the query. When a query is run the output will appear in a grid view called the Result Grid, in the bottom half of the pane, like so. Your ‘show databases’ query will produce different results than what is shown in figure; the result grid shows databases loaded into your MySQL database at this point. The query window has a tabbed view so you can quickly switch between different statements or functions. The Action Output window shows the time and contents of each SQL statement executed, along with the results of that statement. If a query runs successfully, it will show how many rows it returned – 17 for this simple show databases query. 4
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help