MySQL SELECT INTO OUTFILE Export options

mysql into-outfile
georgepsarakis picture georgepsarakis · Feb 4, 2012 · Viewed 41.7k times · Source

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?

Answer

Mosty Mostacho picture Mosty Mostacho · Feb 4, 2012

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"

Related questions

Include headers when using SELECT INTO OUTFILE?

Is it possible to include the headers somehow when using the MySQL INTO OUTFILE?

Read More
MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777

Any ideas? SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*' LINES TERMINATED BY '\n' FROM tbl_property WHERE managerGroupID = {$managerGroupID} Error: Access denied for user 'asdfsdf'@'localhost' (using …

Read More
MySQL export into outfile : CSV escaping chars

I've a database table of timesheets with some common feilds. id, client_id, project_id, task_id, description, time, date There are more but thats the gist of it. I have an export running on that table to a CSV …

Read More