Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

How to output mysql query result into a file

See sql script below:

SELECT code, name, continent, region 
FROM 
country 
INTO OUTFILE 'c:/temp/countries.csv' 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n';
How to output mysql query result into a file How to output mysql query result into a file Reviewed by Edward Legaspi on Thursday, March 10, 2016 Rating: 5

No comments:

Powered by Blogger.