ALTER TABLE `days` ADD COLUMN `name_english` VARCHAR(45) NULL AFTER `name`; UPDATE `days` SET `name_english`='MONDAY' WHERE `id`='1'; UPDATE `days` SET `name_english`='TUESDAY' WHERE `id`='2'; UPDATE `days` SET `name_english`='WEDNESDAY' WHERE `id`='3'; UPDATE `days` SET `name_english`='THURSDAY' WHERE `id`='4'; UPDATE `days` SET `name_english`='FRIDAY' WHERE `id`='5';