Skip to content

Instantly share code, notes, and snippets.

@gedankennebel
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.
Load data from a CSV fiel to MySQL
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