MySQL SELECT INTO OUTFILE Export options

Question

Does anyone know where can I find the documentation for all the export options of the SELECT ... OUTFILE statement of MySQL? I have noticed in multiple questions parameters such as

FIELDS ENCLOSED BY delimiter
FIELDS ESCAPED BY delimiter
FIELDS TERMINATED BY delimiter

but I haven't managed to find the complete list of parameters yet. Can somebody please help?

Hypo

Answer 1

This is the official documentation.

You might want to take a look at this too, as it seems the syntax from [FIELDS] and [LINES] is taken from the "load data infile"

Compliant

Really useful links. For some strange matter they wouldn't come up in my search. I didn't think of looking in the LOAD DATA INFILE either. Great answer, thanks! – Hypo

same as wisefish. didn't come up in my search and I did not think to look at the docs for load data infile – Candicandia