Egor Egorov wrote:
Paul McNeil [EMAIL PROTECTED] wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
Except if you are ready to make a User-defined function to make a simple
group_concat...
Philippe Poelvoorde [EMAIL PROTECTED] wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
Except if you are ready to make a User-defined function to make a simple
group_concat...
Philippe, If he is pre-4 (I assume that as he does not seem to have the
GROUP_CONCAT() function) and UDFs aren't available until 5+, how exactly
would he do this as a UDF? :-D
Paul, I believe you are going to have to combine those fields during some
form of post-query processing (macro,
Good morning to all.
How can I combine the elements from many text fields into one text field.
I have a table.
ID(auto inc) eventID data
ID is unique
eventID is repeated
data represents what happened at this event.
I would like to return all of the data for a given event ID, sorted
Paul McNeil [EMAIL PROTECTED] wrote:
How can I combine the elements from many text fields into one text field.
See http://dev.mysql.com/doc/mysql/en/String_functions.html, in particular, you
need CONCAT()
I have a table.
ID(auto inc) eventID data
ID is unique
eventID is
Thank you for your response, Egor. My question is whether or not it is
possible to concatenate the fields without knowing the event ID.
pseudo SQL
Select concat(data from all grouped fields) from foo group by (eventID);
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web
If you use mysql 4.1, you can use GROUP_CONCAT(). See the manual for
details http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html.
Michael
Paul McNeil wrote:
Thank you for your response, Egor. My question is whether or not it is
possible to concatenate the fields without knowing the event
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
Microneil research
Sortmonster Anti Spam
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL
Paul McNeil [EMAIL PROTECTED] wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
