Gunnman писал(а):
а мне нужно через '&' 2:11,12:100&3:5:150 CREATE TEMP TABLE IF NOT EXISTS vrem(id INTEGER, txt TEXT);
INSERT INTO vrem SELECT id, box_type||':'||(group_concat (screw_type,','))||':'||count FROM test WHERE id=1 GROUP BY box_type;
SELECT group_concat(txt,' & ') FROM vrem WHERE id=1;
DELETE FROM vrem WHERE 1;