I know this is terrible practice indeed, but I want to use the merged multivalued table for the GUI part of my program. Following is the thing I want.
to something like
Thanks in advance !!
GROUP_CONCAT for it:
select workerid, GROUP_CONCAT(worktype) from t group by workerid
Look at the fiddle here.