MySQLへcsvをloadする方法

Posted on Jun 15, 2018
  load data infile 'account.csv' into table authapi.account
    fields
      terminated by ','
      enclosed by '\\"'
      escaped by '\\'
  lines
    terminated by '\\\\n'