export or outfile the remote query result in my local computer
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.
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.
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.