View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:52 AM
Kasper K
 
Posts: n/a
Default Re: Format query result.

Paul Lautman skrev:
> Take a look at the GROUP_CONCAT function


Hej Paul,

I read about GROUP_CONCAT and it looks like that is what I am looking
for - great!
Next thing, when I try to use it. It comes up with this error, which i
don't get. Cause i follow the mysql manual proberly:

mysql> SELECT wheel_type GROUP_CONCAT(wheel_type) FROM wheels_hjulex
GROUP BY wheel_type;

ERROR 1064 : You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '(wheel_type) from wheels_hjulex group by wheel_type' at line 1

Do you know what causes this?

Cheers,
Kasper K.
Reply With Quote