Question

Which command is used to modify the records of the table?

Answer 1

Answer:

The alter command is used when we want to modify a database or any object contained in the database. The drop command is used to delete databases from MySQL server or objects within a database. The rename command is used to change the name of a table to a new table name.

Answer 2

Answer:

Alter command is used to modify the records of the table.

Explanation:

The alter command is used for modifying the existing database, tables, its views or any other database objects. The alter syntax will be as follows,

ALTER Table - name ADD COLUMN col - name ‘data type’;

Here the alter table is the command which is used for referring the MYSQL server to modify the table name, by adding new column of given data type. Here two commands are used one is Alter and second is add.