How To Rename MySql Column ?

You can rename column in MySql using "CHANGE" along with "ALTER". Here is an example...

Here we want to rename/change the column "telephoneno" to "Mobileno" in table "addressbook".

Mysql> alter table addressbook change telephoneno Mobileno int(10);