ALTER MySQL Table

ALTER MySQL TABLE :

ALTER TABLE is used to change the structure of an existing table. We can add or delete columns, change the type of existing columns, or rename columns or the table itself. We can also change the comment for the table and type of the table.

Syntax :

The below table will describe the alter specification :

Alter Specification	Description
Rename	Rename a Table name
Add	Add a new column, key, index
Add First	Add a column First
Add After	Add a column After
Drop	Drop a column, Index, key
Change	Change a column name
Change Type	Change a column type
Modify	Modify a column type

The below descriptions shows how to alter mysql tables using queries.

Renaming a Table :

We can also RENAME the table using ALTER TABLE. The following example query renames the table student to class.
The above query will change the table name.

Adding a column to a table :

The ADD COLUMN modifier is used to add a column to a table. The following example query adds a field called marks to the student table.
Next we move to the alterations in displaying the tables.