MySQL, how to solve this problem using dynamic pivot
I want to create a dynamic_view using a stored procedure for the following scenario. Table1 has three columns (id, name, operations), and it has the following three records. id|name|operations ------------------ 1 | a |min,max 2 | b |min,max,avg 3 |…