How to seperate an enum-value column to each value a bool column in MySQL

I have a table:

Now I have to downgrade the paradigms of data, make them be flat and wide. Because they will be fed into an analysis enviroment which has no such data relationships. (actually, it's Elasticsearch)
Finally the selected data must be like this:

Could you tell me how I can do that?

The categories field is enumrable, I can manually create each column.


View on Stack Overflow