UPDATE `ohrm_audittrail_request_details_trail`
SET `affected_entity_name` = CONCAT(SUBSTRING(CONCAT("000000",`id`),-6),' - ',`affected_entity_name`);