mysql substring group_concat code example

Example: group by mysql and concatenate string

mysql> select Id,group_concat(Name SEPARATOR ',') as GroupConcatDemo from GroupConcatenateDemo
   -> group by Id;