LU07.S01 - SQL-DDL: DB Management

Make sure, that your MySQL database system is running and connect with you webstorm editor to your database with your DBA credentials (user: root, password: yourPW).

Windows

CTRL + Shift + ESC –> Dienste –> Filtering the resultset to MySQL

MacOS …

Display all instances which are currently running on our database.

Create the database instances

• myDB_PERFECT
• myDB_OK
• myDB_OBSOLETE

and display your result.

Drop the instance „myDB_obsolete“, as it obviously obsolete (no longer needed). Display the result.

Activate the instance „myDB_PERFECT“ by using the USE command.

Display the system date by using the command „SELECT sysdate();“

Congratulations!! You have just received a first respond from your database „mydb_perfect“.

Volkan Demir