splitting the column fields into new columns in mysql

Asked Jun 21 '17 at 19:31

Active Jun 22 '17 at 14:20

Viewed 46 times

I need some help with some basic, i suppose, mysql. given three columns such as the ones below:

[Events              Counts                Date
 play                    2                 2017/06/05
 pause                   3                 2017/06/05
 first quartile          4                 2017/06/05
 play                    10                2017/06/06
 pause                   12                2017/06/06][1]

How can I split the column event into new columns such Play column, pause columns and so on, having each of these new columns the relative data coming from the initial table? Below you can find the link of what the resulting table should be looking like Thanks

edited Jun 22 '17 at 14:20

asked Jun 21 '17 at 19:31

Alessandro Longo

2

Are you looking for [transposition](https://stackoverflow.com/q/3392956/2298301)? – Dhruv Saxena Jun 21 '17 at 20:15
Show you desired output in a manner similar to how you've presented your sample source data. – Uueerdo Jun 21 '17 at 20:21
@DhruvSaxena. Cheers. it's what i am looking for. Thanks Again – Alessandro Longo Jun 21 '17 at 20:47
What query did you use to get those 3 columns? Add it to the question. Then, manually create the layout of that data that you want (called the "expected result") – Paul Maxwell Jun 22 '17 at 01:41
The solution i got is not working. i'm gonna update the question with the expected end result i want to get – Alessandro Longo Jun 22 '17 at 14:15

splitting the column fields into new columns in mysql

0 Answers0