xxxxxxxxxx
#Alter is used
#alter table TableName change CurrentColumnName NewColumnName Specification(size);
alter table TableName change name firstname varchar(30);
xxxxxxxxxx
ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;
xxxxxxxxxx
ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;
xxxxxxxxxx
ALTER TABLE table_name
MODIFY column_name column_definition
[ FIRST | AFTER column_name ];