LOAD DATA LOCAL INFILE [Csv file path] IGNORE
INTO TABLE [Table Name]
FIELDS TERMINATED BY "," ENCLOSED BY \'"\' # 区切り文字、閉じ文字指定
LINES TERMINATED BY "\n" # 改行コード指定
SET
  zip = NULLIF(zip, ""); # 条件が指定できる