MySQL Bugs: #74674: Import data to record set: Allow other separators

Bug #74674	Import data to record set: Allow other separators
Submitted:	4 Nov 2014 1:14	Modified:	2 Feb 2018 10:36
Reporter:	Philip Olson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	6.2.3	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	csv, import

Description:
The following StackOverflow question inspired this feature request:

http://stackoverflow.com/questions/14313708/import-text-file-into-mysql-workbench

Currently we can only import comma separated value (CSV) files into the result set. It would be nice if could define the separator (FIELDS TERMINATED BY '???') instead of requiring commas. In the above question, they use a pipe symbol.

FWIW, the result set export feature allows commas, semi-colons, or tabs.

How to repeat:
Attempt to import a file that is not separated by commas.

1. SELECT * FROM sakila.actor;
2. Export/Import: Import records from an external file
3. Look for way to define the separator 

Suggested fix:
Allow the user to define the separator, but default to a comma.

Thank you for the feature request.