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
See sql script below:
0 nhận xét:
Đăng nhận xét