ALTER TABLE `TABLE 4` CHANGE `COL 2` `COL 2` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 5` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 8` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 11` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 14` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 17` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 20` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 23` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 26` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 29` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 32` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 35` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 38` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 41` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 44` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 47` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 50` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 53` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';
INSERT into `TABLE 4` (`COL 1`,`COL 2`) SELECT `COL 1`, `COL 56` from `TABLE 4`;
DELETE  FROM `TABLE 4` WHERE `COL 2` IS NULL;
DELETE  FROM `TABLE 4` WHERE `COL 2` = '';