ALTER TABLE `sta_Event` ADD `residentPrice` DECIMAL(11,2) NULL DEFAULT NULL AFTER `memberPrice`; UPDATE `sta_Event` SET `residentPrice` = `memberPrice`;