Help with GROUP_CONCAT (MySql)

Question

Help with GROUP_CONCAT (MySql)

Navigation

#1 by (0 votes)

2

I would like to use grupo_concat for filename and answer but would not repeat the values of filename and answer

Follow sqlfiddle:

link

It is a question that has 2 images and 4 alternatives of A-D.

name        questionText        question    filename    answer
PT-D08-H    Texto da questão    1           2.svg       Resposta A
PT-D08-H    Texto da questão    1           3.svg       Resposta A
PT-D08-H    Texto da questão    1           2.svg       Resposta B
PT-D08-H    Texto da questão    1           3.svg       Resposta B
PT-D08-H    Texto da questão    1           2.svg       Resposta C
PT-D08-H    Texto da questão    1           3.svg       Resposta C
PT-D08-H    Texto da questão    1           2.svg       Resposta D
PT-D08-H    Texto da questão    1           3.svg       Resposta D

This is the result I'm getting, when using group_concat, how to do not to repeat the values of filename and answer

    name        questionText    question         group_concat(filename)                             group_concat(answer)
    PT-D08-H    Texto da...     1                2.svg,3.svg,2.svg,3.svg,2.svg,3.svg,2.svg,3.svg Resposta A,Resposta A,Resposta B,Resposta B,Resposta C,Resposta C,Resposta D,Resposta D

mysql sql

asked by anonymous 03.08.2018 / 21:21

1 answer

Zip Code Search [closed] Classes nested in Java are like closures?

score 0 · Accepted Answer

I decided to make two views , one for perguntas and another for respostas , then just select the two doing join, and using group-concat to answer and filename , worked perfectly, follows fiddle with the solution:

link