Computer scienceFundamentalsSQL and DatabasesDBMSMySQLData Definition Language

Alter table

Adding new column to the table

Report a typo

Bearing in mind the ALTER TABLE command in MySQL, which of the following code snippets correctly adds a new column age of data type int to an existing table Students?

Select one option from the list

TABLE Students ALTER ADD age INT;

ALTER TABLE Students ADD COLUMN age INT;

ALTER Students ADD age INT;

ALTER TABLE Students INCLUDE age INT;

ALTER TABLE Students ADD age INTEGER;

___

Create a free account to access the full topic