December 21, 2009

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);
Posted by Vidhu at 7:04 AM
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)