Question: Use MySQL 1. start the TEE logging command and store your work to the m1u2a2.txt file 2. create a database named ADDRESSES 3. switch to

Use MySQL

1. start the TEE logging command and store your work to the m1u2a2.txt file 2. create a database named ADDRESSES 3. switch to the ADDRESSES database 4. create a table named PEOPLE with the following columns firstname char with 15 characters middlename char with 10 characters lastname char with 10 characters 5. create a table named BUYERS with the following columns firstname char with 10 characters lastname char with 20 characters address char with 15 characters 6. create a table named DROPME with the following columns firstname char with 10 characters lastname char with 20 characters address char with 15 characters amtowed float with 4 digits and 2 decimal places (example: 10.34) 7. show all the tables in the ADDRESSES database 8. remove the DROPME table 9. show all the tables in the ADDRESSES database (you should only see PEOPLE and BUYERS) 10. show all databases

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!