Question: Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called my_first_database. 2) create a table called customer_t. The

Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called

Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called "my_first_database". 2) create a table called "customer_t". The table should include the following column: Customer ID, Customer_Name, Email, City, and Country. 3) add a new column Customer Age to the table "customer_t". 4) delete the column Email from the table "customer_t"! 5) delete the entire table "customer_t". Use CREATE, INSERT, DELETE, and UPDATE commands to write the SQL codes. 1. create a Persons table with the following column: Full names, Age, Gender, City 2. Insert the following two rows in the person table. Full names Age Sheldon Cooper 30 Janet Jones 20 3. Change the city to San Francisco for Janet Jones. 4. Delete the record of Sheldon Cooper. gender Male Female City LA LA

Step by Step Solution

3.46 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

A 1 Create database myfirstdatabase 2 Create table cu... View full answer

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!