Skip to content

Instantly share code, notes, and snippets.

@gedankennebel

gedankennebel/gist:7869922

Created December 9, 2013 09:59
Show Gist options
  • Save gedankennebel/7869922 to your computer and use it in GitHub Desktop.
Save gedankennebel/7869922 to your computer and use it in GitHub Desktop.
Download ZIP
Load data from a CSV fiel to MySQL
Raw
gistfile1.sql
LOAD DATA LOCAL INFILE '/path/to/my/csv/file.csv'
INTO TABLE test.myTable
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment