Skip to content

Instantly share code, notes, and snippets.

@ombak

ombak/mysql_export_table_menjadi_csv_file_2.sql

Last active May 28, 2020 00:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ombak/b4a491ca9e03c4ddb5e9d231be05e870 to your computer and use it in GitHub Desktop.
Save ombak/b4a491ca9e03c4ddb5e9d231be05e870 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_export_table_menjadi_csv_file_2.sql
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