Schema or database?
A database is also known as schema. You can use Query Browser to create databases (schemata).
To create a database:
Launch Query Browser
Log in as root
Right click empty space in Schemata pane, select Create New Schema
Key in a name for your database (e.g. ragnarok)
Click OK
While we are here, let us create the databases we need. Repeat the process to create log and cp databases.
To add a table to a database:
Refer to Figure qb-18:
- Highlight the target database
- Right click, select New Table and do the necessary.
- Apply Changes
Alternatives
You can also add tables to databases by using the Catalog function of MySQL Administrator or by running query scripts
MySQL Administrator catalog
Click Catalog on the left pane
Highlight (e.g. ragnarok) to its contents.
Right an empty space in the Schemata) pane, select Create New Schema.
Key in database details.
|
|