Convert column to row [duplicate]

Question

Navigation

#1 by (0 votes)

3

This is the select of my table, the query I'm using follows in the image below:

It brings the normal result, but I wanted it to bring it this way:

Can it be personal?

Select Current:

SELECT id, id_unica, parametro, descricao, produto FROM inventario WHERE produto='Monitor' GROUP BY parametro ORDER BY parametro ASC;

mysql sql-select

asked by anonymous 13.11.2014 / 14:17

1 answer

Pivot table with row and column addition Popup with a magnifying glass [closed]

score 0 · Answer 1

Try using the following:

SELECT id + id_unica + parametro + descricao + produto 
FROM inventario 
WHERE produto='Monitor' 
GROUP BY parametro 
ORDER BY parametro ASC;

If the + sign does not work in MySQL, try the pipe "||" should work.