My query i type into
mysql Query browser
Load data LOACAL infile
into table testtable
fields terminated by "'"
lines terminated by '\r\n\';
This works fine (but not with out using 'LOCAL' on line 1)
Is there any way to do the opposite using LOCAL to send the data to OUTFILE on my LOCAL machine?
write data LOCAL outfile ?
I have this so far
select * into outfile 'C:\\dumpme.txt'
fields terminated by ','
optionally enclosed by '"'
lines terminated by '/n'
>60007 rows effected.
But when i search for the file in c:\ it does not exist.
I have tried '\\' '/' and '\' in the pathing.
I have asked this question on the following link but no go as yet.
I have asked this question, again as now i want to know maybe if its not working due to me not knowing the syntax for LOCAL