Definition: Change is used to alter an existing column in a MySQL table. You can use change to rename a column by providing both the old column name, and the new column name. It is written as: alter table <table name> change [old column name] [new column name] varchar (30) ;
Also Known As: Change Column, Rename Column
This causes the column called "tone" to be renamed to "hue" on the table called "colors".
alter table colors change tone hue varchar (10) ;