How do i...transporse a column table to row vice in mysql

Question

0.00/5 (No votes)

See more:

I have a table like:

Brand     Price   Colour  Size
addidas   500     Black    7
Nike      400     Blue     8
Reebok    200     Red      9

I need to transpose it like:

AttributeName    AttributeValue

Brand                addidas
Price                 500
Colour                Black
Size                   7
Brand                 Nike
Price                 400
Colour                Blue
Size                   8
Brand                 Reebok
Price                  200        
Colour                 Red
Size                    9

What I have tried:

No source still found only found to transpose to row to column vice solutions

Posted 31-Jan-18 17:37pm

Member 13654932

Updated 1-Feb-18 9:09am

Maciej Los

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Animesh Datta · Answer 1 · 2018-01-31T18:54:00

Hello,
As per your requirement I make below solution.Though it is not good approach.

//Create Table
CREATE TABLE a
(
  id int,
  brand varchar(20) ,
  price int,
  color varchar(20),
  size int
) ;

//Insert rows into table
INSERT INTO a (id,brand,price,color,size)
VALUES 
(1,'addidas', 500 ,'Black', 7),
(2,'Nike', 400 ,'Blue' ,8),
(3,'Reebok', 200 ,'Red' ,6) ;

Query to get the required output is

select  AttributeName,AttributeValue from 
(select a.id,1 as 'colid','brand' as 'AttributeName', brand as 'AttributeValue' from a
union 
select a.id,2 as 'colid','price' , price from a
union
select a.id,3 as 'colid','color',color from a
union 
select a.id ,4 as 'colid','size',size from a
)x order by x.id,x.colid

Here colid variable is used to get the attribute value by required order.
Out put is available in This link
Thanks