The ALTER TABLE statement enables the database to change the structure of a table after it has been created. It is possible to modify the structure of a table even if rows have already been inserted into this table. The ALTER TABLE command can do the below things:
Add a column to an existing table
Modify a column that already exists
Syntax:
ALTER TABLE table_name <ADD column_name data_type |
MODIFY column_name data_type>
