ALTER TABLE `vt_UserAddress` ADD `phone` VARCHAR(50) NOT NULL AFTER `country`; update `vt_UserAddress` set `phone` = `phone2`; ALTER TABLE `vt_UserAddress` DROP `phone2`;