Skip to content

Instantly share code, notes, and snippets.

@jgambill

jgambill/gist:49b03b5a088d1e1ce2b5

Created May 6, 2014 22:54
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 jgambill/49b03b5a088d1e1ce2b5 to your computer and use it in GitHub Desktop.
Save jgambill/49b03b5a088d1e1ce2b5 to your computer and use it in GitHub Desktop.
Download ZIP
load csv into mysql #mysql #sql
Raw
gistfile1.sql
LOAD DATA LOCAL INFILE 'C:/path/to/file.csv'
INTO TABLE `tablename`
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(field1,field2,field3)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment