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
Get step-by-step solutions from verified subject matter experts
