ALTER TABLE `table_name`MODIFY COLUMN `column_name2` enum( 'existing_value1', 'existing_value2', 'new_value1', 'new_value2' )NOT NULL AFTER `column_name1`;

ALTER TABLE `table_name`MODIFY COLUMN `column_name2` enum( 'existing_value1', 'existing_value2', 'new_value1', 'new_value2' )NOT NULL AFTER `column_name1`;