Database Design
3 credits
01.09.17 - 05.07.17
Creating Tables with the MySQL Workbench and SQL
Select the Database (schema) to Use
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.