Skip to content
This repository was archived by the owner on Dec 16, 2021. It is now read-only.

Latest commit

 

History

History
14 lines (13 loc) · 300 Bytes

File metadata and controls

14 lines (13 loc) · 300 Bytes

toolbelt

Small tools and script to remember - here be dragons

MySQL

Import data from a /standard/ csv file into a table

LOAD DATA LOCAL INFILE "infile.csv"
INTO TABLE table
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;