Skip to content

Instantly share code, notes, and snippets.

@DeanThompson

DeanThompson/load_outfile.sql

Created July 20, 2015 06:28
Show Gist options
  • Save DeanThompson/bb0355a7a1a63b2e756f to your computer and use it in GitHub Desktop.
Save DeanThompson/bb0355a7a1a63b2e756f to your computer and use it in GitHub Desktop.
Download ZIP
Load data from outfile in mysql server.
Raw
load_outfile.sql
LOAD DATA INFILE 'path/to/file.txt' REPLACE INTO TABLE tablename CHARACTER SET UTF8 FIELDS TERMINATED BY '|' IGNORE 1 LINES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment