Home / Database Structure / Tables / Question No: 84

I want to change data type of an existing column of the table. How to change data type of the column from varchar to char?

This can be changed using ALTER statement. Take an example:

ALTER TABLE `buyers` CHANGE  `first_name` `first_name` CHAR(19);