export or outfile the remote query result in my local computer

ichin posted 7 years ago in General
Hi,

I have connected to remote computer and tried to do "into outfile" but the file generated in remote computer not in my computer.I wonder whether i can export or outfile the remote query result in my local computer and how to make it.
ansgar posted 7 years ago
There is no
SELECT ... INTO LOCAL OUTFILE
.

Well you can just use a query tab for a simple SELECT * FROM yourtable, and then use the "Export grid rows" menu item.
delos posted 4 weeks ago

I am aware of the export function via the UI but I want to run the query daily, the CSV is powering a report. I am getting a SQL Error (1045): Access denied for user So is my syntax correct and it is a pure issue of privileges?

SELECT * from table_name where insert_timestamp > CURDATE() INTO OUTFILE 'C:\my_report.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Please login to leave a reply, or register at first.