MySQL Bugs: #8904: Ability to specify column separator in batch mode

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:	None
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

Description:
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

Yes please attach here your code for our development
to analyze it.

Thanks in advance.

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.

Bug #46713 is set as duplicate of this bug here.

Please also read bug #46713 for getting more details.

Is there still any chance to implement this feature? Because this feature request is more than 4 years old...
Thanks a lot!

Implement --fields-terminated-by for mysql's batch mode

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

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.