Skip to content

Instantly share code, notes, and snippets.

@rajitha-bandara

rajitha-bandara/gist:e74d5be20541751a06a8187da8f46130

Created June 19, 2018 04:46
Show Gist options
  • Save rajitha-bandara/e74d5be20541751a06a8187da8f46130 to your computer and use it in GitHub Desktop.
Save rajitha-bandara/e74d5be20541751a06a8187da8f46130 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Load Data
Raw
gistfile1.txt
LOAD DATA INFILE 'V:/Downloads/Temp/Homes DB(1).csv'
INTO TABLE land_developers FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name, email, phone_1, street, suburb, estate)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment