ALTER TABLE `table`
DROP `group` ,
DROP `value` ,
ADD `group2` INT(255) NULL DEFAULT NULL ,
ADD `group3` INT(255) NULL DEFAULT NULL ,
ADD `group5` INT(255) NULL DEFAULT NULL ,
ADD `group12` INT(255) NULL DEFAULT NULL ;
UPDATE `basename`.`table` SET `group2` = '34', `group3` = '0', `group5` = '0', `group12` = '0' WHERE `table`.`id` = 1;
UPDATE `basename`.`table` SET `group2` = '34', `group3` = '0', `group5` = '0', `group12` = '0' WHERE `table`.`id` = 2;
UPDATE `basename`.`table` SET `group2` = '0', `group3` = '11', `group5` = '0', `group12` = '0' WHERE `table`.`id` = 3;
UPDATE `basename`.`table` SET `group2` = '0', `group3` = '0', `group5` = '12', `group12` = '0' WHERE `table`.`id` = 4;
UPDATE `basename`.`table` SET `group2` = '0', `group3` = '11', `group5` = '0', `group12` = '0' WHERE `table`.`id` = 5;
UPDATE `basename`.`table` SET `group2` = '0', `group3` = '0', `group5` = '0', `group12` = '1' WHERE `table`.`id` = 6;