demo how to reverse mysql group_concat() function

This is a quick note and demo about method to reverse mysql group_concat()function, with customed seperataor ‘-‘, i.e. split values from cell and transpose into rows.

It is also a good example of how ‘cross join’ method helps to perform a recursive
operation without the need of creating stored procedure but simply in a select
statement

繼續閱讀 “demo how to reverse mysql group_concat() function"