gistfile1.sql

DROP TABLE attributes;
CREATE TABLE attributes(
        key VARCHAR,
        value VARCHAR,
        entity_id INTEGER);

INSERT INTO attributes(key,value,entity_id) values ('j','raugaj',1);
INSERT INTO attributes(key,value,entity_id) values ('n','lion',7);
INSERT INTO attributes(key,value,entity_id) values ('f','wolf',19);
INSERT INTO attributes(key,value,entity_id) values ('c','fennec',233);
INSERT INTO attributes(key,value,entity_id) values ('l','squirrel',7);
INSERT INTO attributes(key,value,entity_id) values ('o','hippo',899);
INSERT INTO attributes(key,value,entity_id) values ('p','wasp',88);
INSERT INTO attributes(key,value,entity_id) values ('i','pichi',19);
INSERT INTO attributes(key,value,entity_id) values ('b','crab',233);
INSERT INTO attributes(key,value,entity_id) values ('m','earthworm',500);
INSERT INTO attributes(key,value,entity_id) values ('g','bullfrog',1435);
INSERT INTO attributes(key,value,entity_id) values ('k','aardvark',999);
INSERT INTO attributes(key,value,entity_id) values ('e','gazelle',8282);
INSERT INTO attributes(key,value,entity_id) values ('a','gorilla',500);
INSERT INTO attributes(key,value,entity_id) values ('h','monkfish',1);
INSERT INTO attributes(key,value,entity_id) values ('d','lizard',88);
INSERT INTO attributes(key,value,entity_id) values (null,null,1);

SELECT group_concat(key),group_concat(value) FROM attributes ORDER BY entity_id;