Database Reference
In-Depth Information
Note
Obtaining MySQL Workbench MySQL Workbench is not installed as part of the
MariaDB installation (nor MySQL installations, actually). Instead, it must be downloaded
Windows, and source code is downloadable, too).
When MySQL Workbench is launched, you see a screen organized in three
columns. From left to right these are:
SQL Development
—Used to connect and actually perform database
and table operations, including executing SQL statements. If you opt
to use MySQL Workbench with this topic, the Open Connection To
Start Querying option is what you use.
■
Data Modeling
—Used to create and manage database and table struc-
tures. This is not covered in this topic.
■
Server Administration
—Used to manage the MariaDB server,
including stopping and starting the services, importing and exporting
data, and more.
■
Tip
Saving Connections MySQL Workbench needs to know information about your MariaDB
server before it can open a connection to the server for you to use. At a minimum, this
information includes the server address (hostname or IP address) and login information.
Rather than having to enter this every time you use MySQL Workbench, you can save the
details for future use (next time you just double-click on the saved settings to connect).
The SQL Editor screen is accessed via Open Connection To Start Querying in
the SQL Development options. This is where you can type and execute SQL
statements. Note the following:
■
SQL statements are typed into the window at the top of the screen.
When the statement has been entered, click the Execute button (the
one with the yellow lightning bolt on it) to submit it to MySQL for
processing.
■
Generated results (if there are any) are displayed in a grid at the bottom
of the screen, in a tab named Output.
■
The leftmost tab in the bottom section of the screen, named
Overview, lists all available databases (called
schema
here) and the tables
within them. Click on any database to see its tables.
■
You can right-click on tables to have MySQL Workbench write
SELECT
and other statements for you.
