How to use the result of two columns within same table in mysql

Question

I have a table with such kind of data in 2 columns:

TypeOfFruits | Production2014 |
Mangoes         450
Mangoes         100
Berries         50
Berries         75
Mangoes         45
Berries         25

My question is: How can I query the data from those two columns so that I can get a result in new columns like:

production2014 for Mangoes | production2014 for Berries
450                          50
100                          75
45                           25

How many different `TypeOfFruits` could be possible ? – Abhik Chakraborty Aug 14 '15 at 07:30 — Abhik Chakraborty, Aug 14 '15 at 07:30
There is just Mangoes and Berries! – Nsengiyunva Aug 14 '15 at 07:31 — Nsengiyunva, Aug 14 '15 at 07:31

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

Using PIVOT,UNPIVOT in mysql would achive what you want.

Here I found an old discussion about using PIVOT properly,

MySQL pivot table

and here; http://stratosprovatopoulos.com/web-development/mysql/pivot-a-table-in-mysql/

edited May 23 '17 at 11:58

Community

1
1

answered Aug 14 '15 at 07:35

sulhadin

521
4
16

oh ...lemme look through that! #Thanks – Nsengiyunva Aug 14 '15 at 07:36

How to use the result of two columns within same table in mysql

1 Answers1