How to rename column in MySQL???
Posted: Fri Jul 02, 2004 8:01 am
Hi everyone, I need to rename a MySQL column. I searched in many forums, but nothing. Can anyone help me? Thanks in advance.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
ALTER TABLE `YourTableName` CHANGE `OldColumnName` `NewColumnName` VARCHAR(20) DEFAULT NULL