jeevandongre/import_csv.sql

Created September 29, 2015 08:44

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jeevandongre/1ee95b373dcce0422e19.js"></script>
Save jeevandongre/1ee95b373dcce0422e19 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

jeevan dongre created this gist Sep 29, 2015.

import_csv.sql

-Original file line number
+Diff line change
@@ -0,0 +1,6 @@
+    LOAD DATA LOCAL INFILE 'file_name.csv'
+    INTO TABLE table_name
+    FIELDS TERMINATED BY ','
+    ENCLOSED BY '"'
+    LINES TERMINATED BY '\n'
+    IGNORE 1 ROWS;