Query to create new colum

--  creates column
alter table disbursement_sheet_raw_data
add composite_id varchar (15) default null;

-- adds unique value to column
update disbursement_sheet_raw_data
set composite_id = concat(SUBSTRING(ds_id_of_icr, - 8), cast(row_no_of_icr as char(2)))