Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

Database Design (Online)

CSYS2643

3 credits

2011Summer

06.06.11 - 07.31.11

Database Design (Online)

CSYS2643

Online
12:00 AM - 11:59 PM

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.