-- Create example table

CREATE TABLE `test` (

  `id_profile` VARBINARY(36) NOT NULL,

  `id_profile_type` INT(10) UNSIGNED NOT NULL,

  `dynamic_cols` BLOB,

  PRIMARY KEY (`id_profile`)

) ENGINE=INNODB DEFAULT CHARSET=utf8

-- Fill table with some data

INSERT INTO `test` (`id_profile`,`id_profile_type`,`dynamic_cols`)  VALUES

('f9854cb9-aacb-11e5-98e4-0050563c3a6d', 1, COLUMN_CREATE('sum',200)),

('00a65240-aacc-11e5-98e4-0050563c3a6d', 2, COLUMN_CREATE('sum',300)),

('0a843922-aacc-11e5-98e4-0050563c3a6d', 1, COLUMN_CREATE('sum',100));

-- Here I want add new dynamic column to existed column

INSERT INTO `test` (`id_profile`,`id_profile_type`, `dynamic_cols`)  VALUES

('f9854cb9-aacb-11e5-98e4-0050563c3a6d', 1, COLUMN_CREATE('addition_col','100500')),

('00a65240-aacc-11e5-98e4-0050563c3a6d', 2, COLUMN_CREATE('addition_col','200300')),

('0a843922-aacc-11e5-98e4-0050563c3a6d', 1, COLUMN_CREATE('addition_col','000200'))

ON DUPLICATE KEY UPDATE

`dynamic_cols` = COLUMN_ADD(`dynamic_cols`, VALUES(`dynamic_cols`));