Skip to content

Instantly share code, notes, and snippets.

@technoknol

technoknol/Load-Import CSV file to MySQL using Query.sql

Created January 29, 2018 07:17
Show Gist options
  • Save technoknol/507a8f0958daef84d27079591ce287e4 to your computer and use it in GitHub Desktop.
Save technoknol/507a8f0958daef84d27079591ce287e4 to your computer and use it in GitHub Desktop.
Download ZIP
Load/Import CSV file to MySQL using Query
Raw
Load-Import CSV file to MySQL using Query.sql
LOAD DATA LOCAL INFILE
'products.csv'
INTO TABLE ws_store_products
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(article_no,store_code,description,qty,mrp,sp);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment