how to change column name in sql database code example

Example 1: change column name sql

ALTER TABLE `db_name`.`table_name` 
	CHANGE `current_column_name` `new_column_name` datatype(size) NOT NULL COMMENT '';

ALTER TABLE users
 ALTER COLUMN first username varchar(20);