Question

Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age and G_name.

After creating the table, she realized that the attribute, Category has to be added. Help her to write a command to add the Category column. Thereafter, write the command to insert the following record in the table:

Game_id: G42
P_Age: Above 18
G_name: Chess
Category: Senior 

Answer 1

Alter table Sports ADD Category varchar(20); Insert into Sports values("G42","Above 18","Chess","Senior");