ALTER TABLE `qs_Testimonial` DROP `address`; ALTER TABLE `qs_Testimonial` ADD `jobTitle` VARCHAR( 50 ) NOT NULL AFTER `name` , ADD `company` VARCHAR( 50 ) NOT NULL AFTER `jobTitle`; UPDATE `qs_Testimonial` SET `company` = 'Company Name' WHERE `company` = '';