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';

Related Posts:

0 nhận xét:

Đăng nhận xét