RENAME column in table
Syntax:
ALTER TABLE table_name
CHANGE COLUMN old_name new_name
column_definition
[ FIRST | AFTER column_name ]
Example:
In this example, we will change the column name “cus_surname” to “cus_title”.
Use the following query to do this:
ALTER TABLE cus_tbl
CHANGE COLUMN cus_surname cus_title
varchar(20) NOT NULL;
Output:
