MySQL select - Adding duplicite rows data to new columns

Asked Sep 26 '18 at 13:55

Active Oct 08 '18 at 16:35

Viewed 17 times

I have this two tables in MySQL (MariaDB):

Table DATA

+------+------+
|id    |object|
+------+------+
|1     |AFD   |
+------+------+
|2     |AFG   |
+------+------+
|3     |ASD   |
+------+------+
|4     |BDS   |
+------+------+
|5     |BDF   |
+------+------+

Table WORK

+------+------+
|id    |action|
+------+------+
|1     |34    |
+------+------+
|1     |54    |
+------+------+
|1     |65    |
+------+------+
|2     |73    |
+------+------+
|2     |11    |
+------+------+

To every id in table DATA there are several id's in table WORK. I need to get the output like this:

+------+------+-------+-------+-------+
|id    |object|action1|action2|action3|
+------+------+-------+-------+-------+
|1     |AFD   |34     |54     |64     |
+------+------+-------+-------+-------+
|2     |AFG   |73     |11     |NULL   |
+------+------+-------+-------+-------+
...

Thank you in advance.

edited Oct 08 '18 at 16:35

Rick James

135,179
13
127
222

asked Sep 26 '18 at 13:55

culter

5,487
15
54
66

1

you are looking on how to build a pivot table – Lelio Faieta Sep 26 '18 at 13:59
I didn't know about pivot table, now I can google it. Thanks. Maybe one question. Is this effective on tables with 100k+ rows? – culter Sep 26 '18 at 14:07

MySQL select - Adding duplicite rows data to new columns

0 Answers0