mysql rename the column of table

 alter table tableName change old_column_name new_column_name data_type;

example:

 alter table users `name` `first_name` varchar(255);