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 is used to modify the structure of an existing table. The command ADD Category VARCHAR(20) adds a new column named Category with a data type of VARCHAR and a maximum length of 20 characters. The INSERT INTO statement is used to add a new record to the table Sports. The column names and their corresponding values are specified. The resulting table Sports will now include the 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} \]