New answers tagged export
In windows use \\ or / while using in path of file. your command should be as follow SELECT * INTO OUTFILE 'C:\\Users\\Jim Smith\\Desktop\\zyzyz.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\r\n' from limit 5; or SELECT * INTO OUTFILE 'C:/Users/Jim Smith/Desktop/zyzyz.csv' FIELDS TERMINATED BY ',' ...
I found a solution for at least my problem. It's possible to put results into a temporary table and unload the temp table. So something like: SELECT * INTO #tmpresultset FROM myTable UNLOAD TABLE #tmpresultset to '/some/file'
Top 50 recent answers are included