Skip to content

Instantly share code, notes, and snippets.

@justdoit0823

justdoit0823/load_csv_into_mysql.sql

Created August 10, 2017 06:16
Show Gist options
  • Save justdoit0823/b982644b2224a9bfe310fcceb878016a to your computer and use it in GitHub Desktop.
Save justdoit0823/b982644b2224a9bfe310fcceb878016a to your computer and use it in GitHub Desktop.
Download ZIP
How to load csv file into MySQL table
Raw
load_csv_into_mysql.sql
load data infile 'src.csv' into table dest_table FIELDS TERMINATED BY ',' ENCLOSED BY '"';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment