Bug #8904 Ability to specify column separator in batch mode
Submitted: 2 Mar 2005 20:30 Modified: 3 Mar 2005 7:01
Reporter: Rob LoPresti Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:4.1, 5.0, 5.1, 5.4, 6.0 OS:Any (All)
Assigned to: CPU Architecture:Any

[2 Mar 2005 20:30] Rob LoPresti
In the mysql command line executable, when running in batch mode, currently all output *MUST* be tab delimited if the output goes to stdout rather than using the 'INTO filename' option.

I would like to see the ability to specify the output field delimiter.  I've coded and tested a version of this myself and am willing to submit the code if that helps gets this done.

How to repeat:
See Description
[2 Mar 2005 20:35] MySQL Verification Team
Yes please attach here your code for our development
to analyze it.

Thanks in advance.
[3 Mar 2005 6:41] Rob LoPresti
In the code I submitted, I called the command to change the delimiter "outdel" for "output delimiter", but I wonder if "colsep" might be better, since that's the equivalent command in oracle.
[14 Aug 2009 10:27] Susanne Ebrecht
Bug #46713 is set as duplicate of this bug here.

Please also read bug #46713 for getting more details.
[14 Aug 2009 16:32] Markus Drexelius
Is there still any chance to implement this feature? Because this feature request is more than 4 years old...
Thanks a lot!
[21 Aug 2009 18:02] Jim Winstead
Implement --fields-terminated-by for mysql's batch mode

Attachment: fieldsterm.diff (application/octet-stream, text), 4.58 KiB.

[21 Aug 2009 18:05] Jim Winstead
The attached patch is a partial implementation of what I think this feature requires. In addition to adding --fields-terminated-by, I think support for the other --fields-* switches that mysqldump supports would be useful.

I'm not sure it is necessary or useful to include commands like 'fieldsterm' for interactive use. I think the command-line switches are probably enough.

If someone wants to carry this work forward, please read http://forge.mysql.com/wiki/Contributing_Code.