MySQL Bugs: #76077: SELECT INTO LOCAL OUTFILE

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.