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

Hint:

Use the ALTER TABLE} command to add new columns and the INSERT INTO} command to add records to a table in MySQL.

Answer 1

-- Step 1: Add the Category column to the table
ALTER TABLE Sports ADD Category VARCHAR(20);

-- Step 2: Insert the given record into the table
INSERT INTO Sports (Game_id, P_Age, G_name, Category)
VALUES ("G42", "Above 18", "Chess", "Senior");
    

Explanation: The ALTER TABLE statement modifies an existing table's structure. The command ADD Category VARCHAR(20) introduces a new column named Category with a VARCHAR data type and a maximum length of 20 characters. The INSERT INTO statement adds a new record to the Sports table, specifying column names and their respective values. The updated Sports table will now contain the following record: \[ \begin{array}{|c|c|c|c|} \hline \textbf{Game\_id} & \textbf{P\_Age} & \textbf{G\_name} & \textbf{Category} \\\ \hline G42 & Above 18 & Chess & Senior \\\ \hline \end{array} \]