Dynamic PIVOT table in mysql

Question

0.00/5 (No votes)

See more:

Hi ,
I have a data as below:

Table

country     date                value       
------------------------------------------------------
test1       5/1/2008            500
test1       5/7/2008            200 
test1       5/8/2008            300
test1       7/1/2008            100
test1       7/2/2008            100
test2       6/1/2008            100

And I want a result as below:

Result

-----------
countryName          May-08         Jun-08      July-08
test1                1000             -          200
test2                 -              100

How can I create a month name as a column name for a given date range in mysql?

[edit]Code block added - OriginalGriff[/edit]

Posted 1-Oct-13 1:43am

Dhrisya P Nair

Updated 25-Mar-18 23:21pm

OriginalGriff

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-10-03T00:46:00

Solution 2

Check this article

Cross-Tabulation (Pivot Tables) with MySQL[^]

Posted 3-Oct-13 0:46am

thatraja

Member 11570476 · Answer 2 · 2018-03-25T23:23:00

country date value
------------------------------------------------------
test1 5/1/2008 500
test1 5/7/2008 200
test1 5/8/2008 300
test1 7/1/2008 100
test1 7/2/2008 100
test2 6/1/2008 100

may sql query send

countryName May-08 Jun-08 July-08
test1 1000 - 200
test2 - 100

Dynamic PIVOT table in mysql

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Dynamic PIVOT table in mysql

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us