Question: Go to MySQL Terminal or workbench, use SQL commands to complete the following tasks. Provide the screenshots of commands and results of each task. 1.1.List

Go to MySQL Terminal or workbench, use SQL commands to complete the following tasks. Provide the screenshots of commands and results of each task.

1.1.List all the databases;

1.2.Create a database

1.3.Create at least three tables in the database that you just created. Each table should contain at least four attributes. Add constraints if needed.

1.4. Add a new column in one of the created tables Note: you could add any new column.

1.5. Drop the column that was just created in task 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!