CREATE TEMPORARY TABLE `temp_table`
AS
SELECT `id` FROM `main_table`;
ALTER TABLE `temp_table` CHANGE `old_name` `new_name_1` int(10);
ALTER TABLE `temp_table` ADD `new_name_2` int(10);
INSERT INTO `temp_table` (`new_name_2`) VALUES (1);
INSERT INTO `main_table_2` SELECT * FROM `temp_table`;
DROP TEMPORARY TABLE `temp_table`;