rmariuzzo · June 10, 2014 16:50
diff --git a/mariadb-dynamic-col.sql b/mariadb-dynamic-col.sql
 use deleteme;

 create table assets (
  item_name varchar(32) primary key,
  dynamic_cols  blob
 );

 INSERT INTO assets VALUES 
  ('MariaDB T-shirt', COLUMN_CREATE('campo_padre', COLUMN_CREATE('hijo', 'valor del hijo')));

 select column_get(column_get(dynamic_cols, 'campo_padre' as char), 'hijo' as char) as a from assets;
	use deleteme;

	create table assets (
	item_name varchar(32) primary key,
	dynamic_cols blob
	);

	INSERT INTO assets VALUES
	('MariaDB T-shirt', COLUMN_CREATE('campo_padre', COLUMN_CREATE('hijo', 'valor del hijo')));

	select column_get(column_get(dynamic_cols, 'campo_padre' as char), 'hijo' as char) as a from assets;