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 "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
A 1 Create database myfirstdatabase 2 Create table cu... View full answer
Get step-by-step solutions from verified subject matter experts
