Skip to content

Instantly share code, notes, and snippets.

@shalaby

shalaby/importCSV.sql

Last active March 30, 2022 10:59
Show Gist options
  • Star 13 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • Save shalaby/deb7edca438c86b45afd to your computer and use it in GitHub Desktop.
Save shalaby/deb7edca438c86b45afd to your computer and use it in GitHub Desktop.
Download ZIP
Import csv to mariadb
Raw
importCSV.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