Bug #76077 SELECT INTO LOCAL OUTFILE
Submitted: 27 Feb 2015 11:10
Reporter: Michael Grazebrook Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.6.20-log OS:Any
Assigned to: CPU Architecture:Any

[27 Feb 2015 11:10] Michael Grazebrook
Description:
For symetry with the LOAD DATA command, it would be useful if SELECT ... INTO OUTFILE could also support a local command. Servers may be well isolated from the user environment and the lack of "LOCAL OUTFILE" renders the select into command useless to non-DBA users.

How to repeat:
select 1 into local outfile '/some/path/myfile.txt';

Suggested fix:
Implement a feature which is the inverse of load data local infile.