Description:
A perhaps-useful enhancement that could be made to MySQL Workbench would be a helper GUI/"wizard" process that assists a user in the construction and execution of the LOAD DATA [LOCAL] INFILE operation.
Whilst this command can be typed directly into the SQL editor, a GUI helper that constructs such a command could lower the bar to making use of this powerful functionality.
As an example of what I am referring to, compare with the text-file loading functionality of some spreadsheet applications such as MS Excel and/or LibreOffice Calc. When opening an unrecognised text file (or in the case of LibreOffice Calc, any text file) the user is presented with a GUI window that allows them to interactively choose the column delimiter character(s), enclosing quotation characters etc - all of the same information that the MySQL LOAD DATA INFILE command uses in order to perform an import.
A great feature of these applications is that they show a preview; a handful of lines from the data-set along with "how they would be parsed into columns, using the current configuration".
I would imagine the process working in a similar manner to the current synchronise with database process (occurring in dialog windows), with the last stage showing the LOAD DATA INFILE command/SQL that the helper/GUI has generated, with a button to go ahead and execute it.
This concept could be taken even further if desired, such that (optionally) the system could also generate a CREATE TABLE command to receive the data (if a table has not yet been created for it).
How to repeat:
N/A - feature suggestion
