Monday 22 May 2017

How to rename an existing column in MySQL ?

MODIFY or CHANGE clause with Alter Command is used too change a column's definition in MySQL.
ALTER TABLE `post` CHANGE COLUMN `read-more` `read_more` VARCHAR(255) NOT NULL;

No comments:

Post a Comment

Advertisement

Advertisement