CHANGE

MySQL

Example

ALTER TABLE Employees CHANGE COLUMN FirstNm FirstName VARCHAR(45);

Output

Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0

Explanation

The CHANGE clause in MySQL is used to change the name and/or data type of a column in a table. In this example, the column named FirstNm is being renamed to FirstName with datatype VARCHAR(45).