mysql select as rename code example

Example: alter rename command in mysql

-- mysql
ALTER TABLE `members` CHANGE COLUMN `full_names` `fullname` char(250) NOT NULL;