Re: Syntax problem - Sybase to MySql
Posted by:
Leo Gil
Date: August 11, 2004 10:49AM
Peter,
MySQL has a function called GROUP_CONCAT which will give you the result you are looking for.
However you have to upgrade your database to at least 4.1 (It doesn't work on 4.0.x)
So your syntax would be:
SELECT GROUP_CONCAT(Category_desc SEPARATOR ',')
Good luck
Leo
Subject
Views
Written By
Posted
3726
August 09, 2004 12:25AM
1999
August 09, 2004 04:20AM
Re: Syntax problem - Sybase to MySql
2512
August 11, 2004 10:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.