ALTER TABLE countries
    ADD COLUMN alpha_3 VARCHAR(3) NULL AFTER code,
    ADD COLUMN numeric_code VARCHAR(3) NULL AFTER alpha_3,
    MODIFY name VARCHAR(150) NOT NULL;

UPDATE countries SET alpha_3 = 'BGD', numeric_code = '050' WHERE code = 'BD' AND (alpha_3 IS NULL OR alpha_3 = '');
