MySQL alter table statement is used to add a column, modify a column, drop a column, rename a column or rename a table.

This video tutorial demonstrates the following:

alter table employees

-change column salary sal double;

alter table sample

-rename to smallEmp;