sahajamit/importCSVInToMariaDB.sql

Forked from shalaby/importCSV.sql

Created November 27, 2018 08:06

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

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

Download ZIP

Import csv to mariadb

Raw

importCSVInToMariaDB.sql

	mysql -uroot -p --local-infile

	LOAD DATA LOCAL INFILE "file.csv"
	INTO TABLE db.table
	FIELDS TERMINATED BY ','
	ENCLOSED BY '\"'
	LINES TERMINATED BY '\n'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment