UPDATE nasdaq_companies SET  `company_name` = REPLACE(REPLACE(company_name, '\n', ''), '\r', '');

-- 10-12-2020
ALTER TABLE `candidate_experiences` ADD `official_email` VARCHAR(255) NULL AFTER `job_title`;
ALTER TABLE `candidate_details` ADD `current_working_email` VARCHAR(255) NULL AFTER `candidate_id`;

