Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT iso, name, nicename, iso3, numcode, phonecode
FROM countries
INTO OUTFILE '/var/lib/mysql-files/countries01.csv'
FIELDS ENCLOSED BY ''
TERMINATED BY ','
ESCAPED BY ''
LINES TERMINATED BY '\r\n';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment