Bug #46713 Ability to change column separator in batch mode
Submitted: 14 Aug 2009 9:25 Modified: 14 Aug 2009 10:26
Reporter: Markus Drexelius Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:4.1, 5.0, 5.1, 5.4, 6.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Aug 2009 9:25] Markus Drexelius 
Description:
When exporting queries in batch mode there es a TAB used as a devider between the columns.

There should be implemented a possibility to change it to any other character.

See also bug report 8904
http://bugs.mysql.com/bug.php?id=8904

How to repeat:
it's no bug, it's a feature request, so nothing to "repeat" ;-)

Suggested fix:
Implementing a new command line option, e.g. --colsep=";" that enables to change the column divider to another character then TAB
[14 Aug 2009 10:26] Susanne Ebrecht 
Many thanks for writing a feature request.

This is a duplicate of bug #8904.
[19 Jan 2012 18:32] Mauro Dionisi 
I solved this issue on linux with following:

$ mysql --batch -e "select * from tmptbl" | sed 's/\t/|/g'

The output has "|" instead of <TAB> chars as field separators.