How to Save Mysql Query Result on a File
See sql script below: SELECT code, name, continent, region FROM country INTO OUTFILE 'c:/temp/countries.csv' FIELDS TERMINATED...

SELECT code, name, continent, region FROM country INTO OUTFILE 'c:/temp/countries.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Post a Comment