DATABASE DESIGN - SQL TABLES
Assignment 2: Demonstration of CREATE, DROP and SHOW commands
Login to the MySQL server and display the current databases already created:
Lab 2: Demonstration of CREATE, DROP and SHOW commands
Login into the MySQL server that you installed in Assignment 1.
Go to the SQL prompt.
At the prompt, use the CREATE DATABASE command to create a new database.
After the CREATE Database command executes, verify that the database is now listed in the system inventory:
Next, Drop the table,.
perform the verification steps
then create the database again
Finally verify that the database is listed again in the inventory: