Loading

Error in mysql query

Error in mysql query

ancy chacko

11y882Learn iOS Programming

hi

my database table is like

sl no	month	data
t1	03	234
t1	04	678
t1	05	1234
t2	03	789
t2	04	0909
t2	05	456

l

but i want like this query

sl.no	data1	dat2	dat3
t1	234	678	123
t2	789	0909	456

please help..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth11y ago
Hi ancy chacko,

Example :

Use GROUP_CONCAT() like this:
SELECT k.id, GROUP_CONCAT(d.value) FROM keywords AS k INNER JOIN data as d ON k.id = d.id GROUP BY k.id
Ref this : http://stackoverflow.com/questions/3664393/how-to-group-mysql-rows-with-same-column-value-into-one-row
0