Page 1 of 1

How to rename column in MySQL???

Posted: Fri Jul 02, 2004 8:01 am
by mishoboss
Hi everyone, I need to rename a MySQL column. I searched in many forums, but nothing. Can anyone help me? Thanks in advance.

Posted: Fri Jul 02, 2004 8:08 am
by anjanesh

Code: Select all

ALTER TABLE `YourTableName` CHANGE `OldColumnName` `NewColumnName` VARCHAR(20) DEFAULT NULL
To make this kind of work easier use phpMyAdmin - http://www.phpmyadmin.net/home_page/