Step 1: Add new Column
ALTER TABLE long_holiday ADD (duplicate_date DATE);
Step 2: Update new Column with existing value
UPDATE long_holiday SET duplicate_date = STR_TO_DATE(start_date , '%d-%m-%Y');