MySQL Forums
Forum List  »  Newbie

Specifying row separators
Posted by: John Zandbergen
Date: July 13, 2005 07:55AM

Hi all,
I want to use a select statement in MySql that gives me one column of a table as a long stream of characters, without any (newline) separators.

I found out:
1. That group_concat does not work because of the limited length. The complete length might be a few megabytes which group_concat does not like. I'm considering setting group_concat_max_len to 10 MB, but I don't think that would be a good idea?

2. Because the data in the database contains newline characters, it is not possible to use some unix-statement to remove the newline separaters MySql adds. This would also remove the intentionally used newlines (\n and \r).

so:
I'm looking for a way to set the output row-separater of the mysql client.....

Any input is welcome.

Thank you,
John

Options: ReplyQuote


Subject
Written By
Posted
Specifying row separators
July 13, 2005 07:55AM


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.