Group data from a Query?

Question

I do a GROUP BY in a query result and the result comes this way:

I wonder if it is possible to bring together in this way?

I wonder if this grouping is best done in PHP or Query and how it can be done?

Follows my code:

Query SQL

SELECT id,cliente, descricao, forma_pgto, bandeira, valor, codigo, data, cod_aut
FROM ItensVendidos
WHERE data BETWEEN '2017-05-22' AND '2017-05-22'
GROUP BY id,cliente, descricao, forma_pgto, bandeira, valor, codigo, data, cod_aut

Answer 1

You can use the GROUP_CONCAT, grouping by COD_AUT, if this is the only common parameter.

Soon:

SELECT id, 
       cliente, 
       GROUP_CONCAT(descricao) as descricao, 
       forma_pgto, 
       bandeira, 
       valor, 
       codigo, 
       data, 
       cod_aut 
FROM   itensvendidos 
WHERE  data BETWEEN '2017-05-22' AND '2017-05-22' 
GROUP  BY cod_aut 

---

This will return as "SALES 1,SALES 2,SALES 3,SALES 4", if you want to show them without comma you can use the SEPARATOR mysql (documentation) and choose the tab you prefer. You can also treat this in PHP using str_replace/strtr or use explode to create an array.