Database Reference
In-Depth Information
6.
Next you need to select the new database (so that when you create the
tables they are created inside it). Type
USE crashcourse;
at the top
of the screen and click the Execute button (the one with the yellow
lightning bolt). The output tab indicates success or failure with an icon
for each statement—red X for failure, blue exclamation mark for suc-
cess.
7.
To create the tables, you need to run the
create.sql
script. Select
File, Open SQL Script, and locate the
create.sql
file. When you see
the contents in the editor window, click the Execute button. The out-
put tab below indicates success or failure with an icon for each state-
ment (multiple statements will be executed).
8.
Repeat step 7, this time using the
populate.sql
script. This populates
the newly created tables with the sample data. Again, the output tab
below indicates success or failure with an icon for each statement.
9.
When you are done, you can quit MySQL Workbench.
You can now return to Chapter 3.
