Threesuns

Email

Contact

All Semesters

Semesters

All Courses

Courses

Database Design

CSYS2643

3 credits

Creating Tables with the MySQL Workbench and SQL

How To
Screenshot from 2017 07 25 08 59 44

Select the Database (schema) to Use

Step 4

Before SQL commands can be executed against your new database you must select it making it the active database. Do this by running the SQL statement:

use mynewdatabase;

Run this statement by typing it into the MySQL Query tab and then clicking the execute button or hitting ctrl-enter on the keyboard.

When this command is successful you'll see the name of your selected database appear as bold in the lower left schema pane.