这个问题在这里已经有答案了：

你能用mysql中的“loaddatalocalinfle”查询定义字段和值吗(2个答案）
两年前关门了。
我有这个声明。其中我需要公司字段是'stackoverflow'而不是从csv值。
上传的csv

alice,bob,support@stackoverflow.com,+3233232,companyx,appointment
alice1,bob1,support1@stackoverflow.com,+3233232,companyy,appointment

sql语句：

$sql = <<<eof
  LOAD DATA INFILE '$target_path'
   INTO TABLE sh_contact
   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
   LINES TERMINATED BY '\n'
  (firstname,lastname,email,mobile,company,type)
eof;

编辑：

LOAD DATA INFILE '$target_path'
INTO TABLE sh_contact
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(firstname, lastname, email, mobile, company, type)
SET company = 'stackoverflow', type='blabla';