[667a13]: generate / run / group_concat.source  Maximize  Restore  History

Download this file

2 lines (1 with data), 219 Bytes

wn0.Sampleset.createview=CREATE OR REPLACE VIEW %wn0.Sampleset.view% AS SELECT synsetid, GROUP_CONCAT (DISTINCT %Sample.table%.sample ORDER BY sampleid SEPARATOR '|') AS sampleset FROM %Sample.table% GROUP BY synsetid;