Specifying row separators
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
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.