ALTER TABLE `thiqljmz_banksfinders`.`creditcardsbenefits` 
CHANGE COLUMN `creditcardsbenefitsDetails` `creditcardsbenefitsDetails` VARCHAR(4000) NULL DEFAULT NULL ;


ALTER TABLE `thiqljmz_banksfinders`.`creditcardsbenefits` 
ADD COLUMN `creditcardsbenefitscategory` VARCHAR(100) NULL AFTER `idcreditcards`;


INSERT INTO `thiqljmz_banksfinders`.`creditcardsbenefits`
(`creditcardsbenefitsDetails`,
`idcreditcards`,
`creditcardsbenefitscategory`)
select dc.detail,cc.idcreditcards,dc.section from excel_data dc 
left outer join creditcards cc  ON cc.creditcardsname COLLATE utf8mb4_general_ci = dc.file_name COLLATE utf8mb4_general_ci
where idcreditcards is not null