Syntax
------

SELECT ... INTO DUMPFILE 'file_path'

Description
-----------

SELECT ... INTO DUMPFILE is a SELECT clause which writes the resultset into a
single unformatted row, without any separators, in a file. The results will
not be returned to the client.

file_path can be an absolute path, or a relative path starting from the data
directory. It can only be specified as a string literal, not as a variable.
However, the statement can be dynamically composed and executed as a prepared
statement to work around this limitation.

This statement is binary-safe and so is particularly useful for writing BLOB
values to file. It can be used, for example, to copy an image or an audio
document from the database to a file. SELECT ... INTO FILE can be used to save
a text file.

The file must not exist. It cannot be overwritten. A user needs the FILE
privilege to run this statement. Also, MariaDB needs permission to write files
in the specified location. If the secure_file_priv system variable is set to a
non-empty directory name, the file can only be written to that directory.

Since MariaDB 5.1, the character_set_filesystem system variable has controlled
interpretation of file names that are given as literal strings.

Example
-------

SELECT _utf8'Hello world!' INTO DUMPFILE '/tmp/world';

SELECT LOAD_FILE('/tmp/world') AS world;
+--------------+
| world        |
+--------------+
| Hello world! |
+--------------+

URL: https://mariadb.com/kb/en/select-into-dumpfile/