Support the SELECT ... INTO OUTFILE syntax

[qw4990]

Feature Request

Is your feature request related to a problem? Please describe:

No.

Describe the feature you'd like:

From MySQL documentation 13.2.10.1 SELECT ... INTO OUTFILE Syntax:

SELECT ... INTO OUTFILE writes the selected rows to a file. Column and line terminators can be specified to produce a specific output format.

It helps us to store the query result in a CSV form.

Here is a discarded PR that may as a reference for you.

NOTE: do not support INTO DUMPFILE and INTO VARIABLES, supporting the INTO OUTFILE syntax is enough in this issue.

[kennytm]

NOTE: do not support INTO DUMPFILE and INTO VARIABLES, supporting the INTO OUTFILE syntax is enough in this issue.

Do you mean supporting INTO DUMPFILE and VARIABLES is fine but not necessary?

[qw4990]

NOTE: do not support INTO DUMPFILE and INTO VARIABLES, supporting the INTO OUTFILE syntax is enough in this issue.

Do you mean supporting INTO DUMPFILE and VARIABLES is fine but not necessary?

Emm yes.