ALTER TABLE vn.addressWaste MODIFY COLUMN `type` enum('external', 'fault', 'container', 'break', 'other') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL; UPDATE vn.addressWaste SET `type`='container' WHERE addressFk=77; UPDATE vn.addressWaste SET `type`='fault' WHERE addressFk=317; UPDATE vn.addressWaste SET `type`='break' WHERE addressFk=57702; UPDATE vn.addressWaste SET `type`='other' WHERE addressFk=43432;